Save a macro button onto a toolbar
EXCEL 2007
Try this:-
1. Office Button (top left hand corner).
2. Excel Options (lower right hand corner).
3. Customize.
On the right hand side in here there is a section called:-
Choose commands from:
Click on the drop down arrow and select Macros.
4. A list of available Macros should appear on the left hand side.
Click the one that you want then click on the Add button.
5. Your Macro should now appear on the right hand side.
6. You can move its position on the Quick Access Toolbar by clicking the up
or down arrows (on the far right hand side).
7. Finally click OK.
8. Your Macro should now be assigned to the Quick Access Toolbar.
If my comments have helped please hit Yes.
Thanks.
"BG Mark" wrote:
I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.
|