Select any cell in the worksheet and then just click the Stop Recording macro button, which is in the exact same location as the Record Macro button in step 2.Nothing else matters here because we just need to record a simple macro, anything really. On the screen that appears, make sure to select Personal Macro Workbook from the Store macro in: drop down box and then hit the OK button.From there, click the Record Macro button: To record a macro go to the Developer tab, if that is visible, or simply look to the bottom left of the Excel window.Open an Excel file and then go to record a dummy macro, recording this dummy macro is what will create the 'personal macro workbook' that we need in order to store the macros.

Steps to Make any Macro Available in All Excel Files All of the macros that we want to use in Excel will be stored within this personal macro workbook and will then be accessible by any Excel file. To do this we need to create what is called a 'personal macro workbook' and then save it. In Excel, you can make it so all of your macros can be easily accessed by any Excel workbook.

Shortcut to save as xlsb alt+