Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM A BUTTON
Target.TextToDisplay = "A-Z"
End Select
End Sub
Method 5: Custom Toolbar (Excel 2003 Only)
In Excel 2003, you can create your own fl oating toolbar. Choose Tools,
Customize. In the Customize dialog, choose the Toolbars tab and then click
New. Type a name for the toolbar and click OK.
Keep the Customize dialog open. Go to the Commands tab. In the left dropdown,
choose Macros. In the right dropdown, drag either Custom Menu Item or the
Custom Button to the new toolbar. Keep the Customize dialog open. Right-
click the new icon in the toolbar. You can choose a new icon, choose a ToolTip,
and assign a macro to the button (Figure 113).
Figure 113. You can customize the
but on on the new toolbar.
Summary: There are several ways to start a macro by using controls that
appear on a worksheet.
 
Search JabSto ::




Custom Search