Customizing toolbars

Toolbars are very common in Windows applications, and Excel offers a huge assortment of built-in toolbars. Generally, toolbar buttons serve as shortcuts for commonly used menu commands to give users a quicker way to issue commands. Because a mouse is required to click a toolbar button, a toolbar button generally isn't the only way to execute a particular operation. Excel's toolbars, for example, make it possible to do most of the common spreadsheet operations without even using the menus.

You can create a custom toolbar that contains only the tools that you want users to be able to access. In fact, if you attach macros to these tools, a custom toolbar becomes the equivalent of a group of buttons placed on a worksheet. The advantage to using the toolbar in this way is that it is always visible and can be reposi-tioned anywhere on the screen. Buttons inserted on a worksheet are fixed in place and can be scrolled off the screen.

Beginning with Excel 97,you can also add menus to a toolbar.

You can set up your application so that the toolbar appears whenever your application is loaded. You do this by attaching a toolbar to a workbook by using the Attach button in the Toolbars tab of the Customize dialog box (see Figure 6-5).

This lets you store individual toolbars with a workbook application so that you can distribute them to users of your application.

Figure 6-5: You can attach a custom toolbar to a worksheet with the Attach Toolbars dialog box.

I discuss toolbars in detail in Chapter 22.

I discuss toolbars in detail in Chapter 22.

Was this article helpful?

0 0

Post a comment