But what if you want to use it in other files too Recreating the same macro for each and every workbook does not sound like a good idea.

Instead, store your popular VBA codes in the Personal Macro Workbook.

This will make the macros accessible every time you open Excel, in any workbook.

A great thing about the personal workbook is that its hidden by default, so you wont ever notice it opening in the backend.

Microsoft Excel just knows the location where this file lives in your system and looks for it automatically on every launch.

Once the Personal.xlsb file is created, you can add any other macros to it by using the VB Editor.

So, to get to the XLSTART folder in Windows Explorer, check the Hidden items box on the View tab.

So, before we get started, please make sure the Developer tab is activated in your Excel.

In the Store Macro in drop-down list, select Personal Macro Workbook and click OK.

Optionally, you can change the default name such as Macro1 to a more meaningful one.

If your goal is just to create a personal workbook, continue with the next step.

Doing this display a message prompting you to save the changes youve made to the Personal Macro Workbook, and you click Save.

Also, you can copy the code you wish to reuse from another workbook.

For this, just open the worksheet in which you want to run the macro, and do the following.

And then, other persons can put your Personal.xlsb file in their XLSTART folder.

For the detailed steps, please see How to copy macros to another workbook.

If the Personal.xlsb file keeps opening whenever you use macros and this really bugs you, you can hide it in this way.

If the file does not delete, that means its still running in the background.

To fix this, open the Task Manager and kill all running Excel processes.

I thank you for reading and hope to see you on our blog next week.

I found your post through a Bing search, but will be exploring your website and products later.

When I clicked OK, I was further informed that the macro would not record.

Thus, either Personal must be checked read-only or Personal must be listed as shared.

How To Move A Sheet To New Workbook In Excel For Mac