| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign a macro to a button
On Dec 11, 3:50 pm, totofab wrote:
How do I assign a macro to a button in the Quick Access Toolbar. And run the macro by just cliking the button and not open the macro file first. Right click anywhere up on the toolbar menu, go to CUSTOMIZE. In the Customize dialogue box, click the COMMANDS tab. In the list on the left, scroll down to MACROS. Then drag either of the buttons on the right up to your toolbar. Now right click the new button and you'll at the buttom: "Assign Macro...". Click that. you can also set other things like the buttom image, what the button says, etc... enjoy! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign a macro to a command button | Excel Discussion (Misc queries) | |||
| Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
| How do I Assign Macro to a button? | Charts and Charting in Excel | |||
| How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
| assign a macro to a control button | Excel Discussion (Misc queries) | |||
Threaded Mode
