Video: Save your macro

To make sure your macro is always available on your computer, save it to your Personal Macro Workbook, which is a special hidden workbook that loads every time you start Excel.

Want more?

Create or delete a macro

Edit a macro

Assign a macro to a button

Create and save all your macros in a single workbook

Now, I want to make sure our macro is always available on this computer.

I can do this by saving it to my Personal Macro Workbook, which is a special hidden workbook that loads every time you start Excel.

I start the Macro Recorder and give this macro the same name as our original macro, FillDaysRelativeR.

But this time, under Store macro in, I choose Personal Macro Workbook and click OK.

Just as quickly, I’ll stop the recording because I didn’t really need to record the steps, because I am just going to copy over them.

I bring up the Macros dialog box, and now you can see the macros I have.

And here is the macro I just recorded in my Personal Macro Workbook, and here is the macro that I want to copy.

I click Edit, which brings up the Visual Basic Editor.

And this is the macro Sub FillDaysRelativeR, so we’ll select all of it, including End Sub.

Copy it and then close the Visual Basic Editor.

And now, I’ll select the macro in my Personal Workbook that I want to edit.

But Excel says that the workbook is a hidden workbook, and we can’t edit a macro.

So, click OK and Cancel.

Now, we’ll unhide the personal workbook.

To do that, click the VIEW tab and then click Unhide.

Here is the hidden workbook, so click OK.

Click the DEVELOPER tab, click Macros, and select the macro in the Personal Workbook.

I click Edit, and here are the limited instructions that we recorded. I’ll just paste over them.

Now I just close the Visual Basic Editor, which saves the changes.

The last thing I want to do is clean up, so I’ll hide the PERSONAL.XLSB file, the hidden workbook.

Click the VIEW tab, switch the window to the Personal Workbook, and click Hide.

From now on, when I work on this computer, whether I open an existing workbook or create a new one, that macro in the Personal Workbook is always available.

The next time I shut down Excel, it’ll ask me if I want to save the changes to the Personal Workbook.

Since I want to save this macro to my Personal Workbook, I’ll click Save.

In the next and final video, I’ll show you how to assign a button to a macro, so it’s just one click away.