When we record macros in Excel, normally they are saved to the active Excel workbook. Then if you close that workbook, recorded macro will no longer be available for other workbooks. But sometimes you may want to use a particular macro in various Excel files. Luckily, Excel has a solution for this. What you have to do is record the macro in the “Personal Macro Workbook”. Then those macros will be available for all the Excel files you open.
But some people are having a problem using this feature. Because when they try to store the macro in the Personal Macro Workbook, Excel shows the following messages to them.
If you are also having this problem, this post will help to solve the issue. Follow these easy steps.
Launch the Excel application. Click on the “FILE” menu.
Then click “Options”.
Excel Options dialog box will open like this. Then click the Add-Ins category.
In the Add-Ins category you can find the “Manage” dropdown at the bottom.
Then select the “Disabled Items” from the dropdown list.
Next click the “Go...” button.
Disabled Items Window will open like this.
Select the personal.xlsb from the list. Then click the “Enable” button.
Close the Disabled Items window. Then close the “Excel Options” dialog box. Now close the Excel application and start it again. You will be able to store the macros in the Personal Macro Workbook again.