How to Save Macro to Personal Macro Workbook?

In this short article, I will show you how you can save Macro to Personal Macro Workbook.

Most macros are created for use in a specific workbook, but it is possible to use some macros in all your work. You can store these general-purpose macros in the Personal Macro Workbook so that these macros are always available to you. The Personal Macro Workbook is loaded whenever you start Excel. A file named personal.xlsb is created only after you have recorded a macro using Personal Macro Workbook as the destination.

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide.

Saving Macro to Personal Macro Workbook

Note: Normally, the Personal Macro Workbook is in a hidden window. To record the macro in your Personal Macro Workbook, select the Personal Macro Workbook option in the Store macro in the drop-down menu in the Record Macro dialog box before you start macro recording.
[/wpsm_box]

save macro to personal workbook

Personal Macro Workbook.

If you store macros in the Personal Macro Workbook, it will open automatically when you load a workbook that uses macros saved in the Personal Macro Workbook. When you will exit, Excel will ask whether you want to save changes (if you have changed anything) to the Personal Macro Workbook.

Happy Excelling 🙂

Read More


Hello! Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply. Keep in mind this African proverb: "If you want to go fast, go alone, If you want to go far, go together." Let's together explore Excel deeply! ☕

1 Comment

      Leave a reply