Microsoft® Office 2007 On Demand

24. Expanding Office Functionality

What You’ll Do

View and Manage Add-ins

Load and Unload Add-ins

Enhance a Document with VBA

View the Visual Basic Editor

Set Developer Options

Understand How Macros Automate Your Work

Record or Create a Macro

Run and Control a Macro

Add a Digital Signature to a Macro Project

Assign a Macro to a Toolbar

Save and Open a Workbook with Macros

Insert and Use ActiveX Controls

Set ActiveX Control Properties

Add VBA Code to an ActiveX Control

Play a Movie Using an ActiveX Control

Change the Document Information Panel

Introduction

An add-in extends the functionality of Microsoft Office programs. For example, Excel includes a variety of add-ins—including Analysis ToolPak, Conditional Sum Wizard, Lookup Wizard, and Solver—that ...