Creating A Macro Button
If you work with macros, why not assign that macro to a button that can be easily clicked on, especially for macros used multiple times. Follow these steps:
- Select View, Toolbars, Customize.
- Click the Commands tab and select Macros in the Categories control.
- Then drag the Custom Button in the Commands control to a toolbar.
- Once you have added the new button, click the Modify Selection button.
- Choose Assign Macro from the resulting shortcut menu.
- Finally, identify the macro you want to attach to the macro button, click OK, and then click Close.
Be sure to have a macro already created before you start this tip or at least have a macro to select.
Tip comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
Just click on the button for the Tiproom's Home Page.
Date of last revision: 22 August 2001.