Richard has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Macros
How do I put a button on the worksheet for a macro?
RE: Macros
Hello Richard
Thank you for your question and welcome to the forum.
You can add a button to your worksheet to run a macro by doing the following:
1. Bring up the Forms toolbar on your screen (View - Toolbars - Forms).
2. Select the Button object from the toolbar.
3. Use your mouse to draw a button on the spreadsheet by clicking and dragging diagonally.
4. When you release the mouse, the Assign Macro dialogue box will automatically pop up. Enter a name for the button and select the macro you wish to run when the button is clicked.
5. Click OK.
I hope this helps.
Amanda