Pages

Personal Macro Workbook in the startup folder must stay open for recording - (How to solve)

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.

Error - Personal Macro Workbook in the startup folder must stay open for recording

Error - Unable to record

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.

Click FILE menu

Then click “Options”.

Click Options

Excel Options dialog box will open like this. Then click the Add-Ins category.

Click Add-Ins category

In the Add-Ins category you can find the “Manage” dropdown at the bottom.

Manage dropdown

Then select the “Disabled Items” from the dropdown list.

Select the Disabled Items

Next click the “Go...” button.

Go… button

Disabled Items Window will open like this.

Disabled Items Window

Select the personal.xlsb from the list. Then click the “Enable” button.

Select personal.xlsb

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.