Related topics
×
Work with macros
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Work with macros

Save your macro

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×