Philip has attended:
Excel Intermediate course
Excel Advanced course
Macros
How can i create a macro shortcut in the toolbar section?
RE: Macros
Hello Philip
Thank you for your question.
You can create a toolbar button to run a macro by doing the following:
1. Go to Tools - Customise.
2. Go to Commands.
3. From Categories on the left, select Macros.
4. Select the Custom Button on the right, use your mouse to drag & drop the Custom Button onto a toolbar at the top of the screen.
5. Once the button is on the toolbar, right-click and select Assign Macro.
6. Select the macro you wish to attach to the button, and click OK.
I hope this helps.
Amanda