Microsoft® Excel 2010 On Demand

16 Expanding Excel Functionality

What You’ll Do

View and Manage Add-ins

Load and Unload Add-ins

Enhance a Workbook 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 ActiveX Controls

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 Excel and other Microsoft Office programs. Excel includes a variety of addins—programs that are included with Excel but not essential to its ...