Macros

Hi Reuben

Thank you for your question and welcome to the forum.

You can create a button on your spreadsheet to run a macro by doing the following:

1. Turn on the forms toolbar: View - Toolbars - Form.
2. Select the Button box from the Form Toolbar.
3. Move your mouse onto the spreadsheet, hold the left mouse down, drag diagonally and release the mouse to create your button.
4. The Assign Macro button box will appear.
5. Select the macro that you wish to attach to the button, and click OK.
6. Highlight the default name for the button you have created, and type the name you wish to give to the button to replace the default name.

Amanda