excel training onsite - Macros

Hi Matthew,

Macros are used to automate tasks you carry out frequently. You need to create them yourself - you can start creating a macro by going to Tools - Macro - Record New Macro.

Once your macro is created, you can add a button to run the macro onto a toolbar by going to Tools - Customise - Commands and choose Macros from the Categories list. The macros you have recorded should be visible in the Commands list on the right. Select your macro then drag it onto a toolbar. By right-clicking on the macro button you can then change the settings for the button.

Regards, Rich