Macros

There will be detailed instructions on how to set up macros for your excel workbook.

 

Creating a button

This creates a box which acts as a button

Setting up the Macro

Here, you type in the name of the macro you want to create, then click RECORD to set the description and what you want it to do.

Here, you can set the description and shortcut for the macro.

After you’ve recorded the things you wanted the button to do, you have functioning buttons.

 

Saving the spreadsheet with macros

Since we added macros, the spreadsheet needs to be saved in a different format. Instead of a regular Excel workbook, it needs to be a Excel Macro-Enabled Workbook.