Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM A BUTTON
You can change the font, font size, alignment, and color of the button. If you
are in Text Edit mode, click the diagonal lines surrounding the button to return
to the dots border. Otherwise, Ctrl+click the button to select the button. Press
Ctrl+1 to edit the font, alignment, size, and more. Right-click the button and
choose Assign Macro to change the macro assigned to the button.
Method 2: ActiveX Button
An ActiveX button looks like a forms button, but it is more ﬂ exible, as you will
soon learn. Follow these steps to build one in Excel 2003:
Select View, Toolbars, Control Toolbox.
Click the Button icon and drag in the worksheet. Notice in Figure 109 that
the Design Mode icon is turned on when you draw a new control. Design
Mode is the icon in the top left, with the ruler, triangle, and pencil. Design
mode has to be on when you are working with this control. When you exit
Design mode, the button you create acts as a button when you click on it.
Figure 109. Design mode must be on to work
with the but on.
Click the second button, the Properties button, to display the properties
for the button. Find the line for Caption. Click in the second column of
the Properties dialog, next to the word Caption , and type the words
that should appear on the button (Figure 110). Note that you can change
the appearance of the button by using properties such as BackColor ,
ForeColor , and Font . While the Caption property is a simple text box
where you can type a new caption, many choices lead to ﬂ y-out menus or
even to new dialog boxes. You can add a picture to the button, change the
color, etc. These features make the ActiveX controls far more ﬂ exible than
the forms controls. Note that you still have not assigned a macro to the