Custom toolbutton creating

The complete macro is shown in Figure 16-1. Right now you ll have to use the Macro Run dialog box to run the macro, which isn t very convenient. Of course you could assign a shortcut key to the macro, as described in Chapter 13. In Chapter 19 you ll learn how to create a custom toolbutton and assign the macro to it. 

There are two ways to create a custom toolbar. One way is to modify an existing toolbar (such as the Standard toolbar). The other way is to create a new toolbar and then proceed to add built-in tools, as described earlier, or custom toolbuttons, as described later in this chapter. This way you can leave the Standard and Formatting toolbars (for example) unmodified and display your own custom toolbar. To create a new toolbar, use the procedure in the following box. 

Two custom toolbuttons, a FullPage(Portrait) toolbutton and a FullPage(Landscape) toolbutton, were created and positioned on the left side of the Standard toolbar. The FullPage macro was assigned to both buttons, as described earlier. 

Custom toolbuttons were created for the Full Page Portrait, Full Page Landscape Chemical Format H2O and Toggle Between Floating Point and Scientific macros. The Chemical Format macro is described in Chapter 16. Module sheets containing these macros should be saved in the Personal Macro Workbook. 

In this chapter you ll learn how to customize Excel s built-in toolbars and how to create new toolbuttons to simplify some of the operations that you perform often. 

Use the Button Editor to edit an existing toolbutton image or create a new one. First, choose Toolbars from the View menu and choose Customize... from the shortcut menu. Right-click on the toolbutton image you wish to edit to display the Toolbars shortcut menu. Choose Edit Button Image... from the shortcut menu to display the Button Editor (Figure 19-9). 

---