Last Updated on April 20, 2020
MS Excel macros can boost your productivity, saving you a lot of the time you spend on doing boring tasks, such as formatting or printing. If you didn’t know by now, find out how you can use a macro across all worksheets:
After you choose Tools, Macros, Record New Macro, in the dialog box, at “Store macro in:“, go and switch from the default This workbook, to Personal Macro Workbook.
This will allow you to use the macro in whatever worksheet (or workbook) you need, without having to open the file you recorded it in every time. If you define a shortcut key for it (see picture), you’ll access it very quickly. If you feel like doing so, you can even assign a toolbar button to your macro. In case you want to launch the macro only once for all the sheets in a workbook, just select all worksheets (press Shift and click on each sheet name tab), then launch the macro. It will run in all selected worksheets.
Attention! Don’t forget to save the Personal Macro Workbook when prompted, otherwise you’ll lose your macro.