Customization allows you to modify and enhance the software to meet your specific needs. You can use standard Windows programming tools and languages that are OLE-aware, such as Microsoft Visual Basic. There are several ways to customize the software:
Customizing with Built-In Commands
You can add built-in commands or macros to the toolbars and menus delivered with the software. To add a button to a toolbar or a command to a menu, you click Tools > Customize. From there, you can click the Menu or Toolbars tab and click the options that you want. For example, if you frequently use the File > Sheet Setup command, you can add Sheet Setup to the Main toolbar for quick access.
The Sheet Setup command button is listed in File categories on the Toolbars tab of the Customize dialog box. For more information about adding commands to a toolbar, see Add a Button to a Toolbar.
If you want to create a new toolbar that does not exist in the software, first click View > Toolbars. Next, click New and type the name of the new toolbar on the New Toolbar dialog box. After you click OK, the Customize dialog box automatically appears so that you can add buttons to the new toolbar.
When you add commands or buttons to the menus or toolbars in the software, the changes that you made appear only if a document is open.
Customizing with Custom Commands
Not only can you add built-in commands or buttons to the software, you can also create your own custom commands or macros that can be added to the menus and toolbars in the same manner. The Tools > Customize command allows you to add macros to the standard menus and toolbars in the software. You can also run the custom commands directly by clicking Tools > Custom Commands and selecting the custom command.
You can create custom commands in Visual Basic or other OLE-aware programming applications. Some of the OLE-aware programming applications are VBA (inside Excel), Visual C++ Delphi, Visual Basic, and so forth.
The software also includes a type library, which contains the objects, properties, and methods available with the product. The online Help that is delivered when you install the Programming Tools component provides a complete reference to the objects, methods, and properties. You can view the type library with Visual Basic's type library browser or the browser for an OLE-aware programming application. A variety of custom commands are delivered with the software; use Tools > Custom Commands to view a list of those custom command.