30 Advanced Excel Tips for 2026

Excel Champs / VBA / Personal Macro Workbook (personal.xlsb)
By Puneet Gogia (Microsoft MVP)

Personal Macro Workbook (personal.xlsb)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

The Personal Macro Workbook (PERSONAL.XLSB) is a hidden workbook that opens every time Excel starts, so its macros work in any file. Excel creates it the first time you record into it: go to View → Macros → Record Macro, set Store macro in to Personal Macro Workbook, click OK, then Stop Recording.

To add your own code, press Alt + F11, expand VBAProject (PERSONAL.XLSB) in the Project window and paste into its module. When you close Excel, click Save at the prompt about the Personal Macro Workbook, or the new code is lost.

On Windows the file is in %appdata%MicrosoftExcelXLSTART. To move your macros to another PC, copy PERSONAL.XLSB into the same folder there, or right-click the module, choose Export File and import it on the other machine. Back the file up, since it holds every macro you’ve saved in it.

Code stored there should refer to ActiveWorkbook and ActiveSheet, not ThisWorkbook, which points to PERSONAL.XLSB itself. Run its macros with Alt + F8, and call its functions in a cell as =PERSONAL.XLSB!FunctionName().

If it opens as a visible window, use View → Hide. If it stops loading, go to File → Options → Add-ins, choose Disabled Items in Manage, click Go and enable it.

If you use a lot of VBA codes like me, then you need to have a place where you can store all of them and use them whenever you need.

But the question is, what’s the best place for this? PERSONAL MACRO WORKBOOK. Yes, that PERSONAL.XLSB workbook. Here’s the crazy thing:

Creating a personal macro workbook and storing all the important macros in it can save you a ton of time and help you use them in all Excel files.

Isn’t that AWESOME?? And today in this post, I’ll be sharing with you everything you need to know about this file. So stay with me for the next 3 to 4 minutes.

What is PERSONAL MACRO WORKBOOK

Personal Macro Workbook is a file that can be the common storage place to store all your macros and use them. It’s a hidden file that opens automatically when you start Excel on your system. And you don’t need to open it separately when you want to access any of the codes from it. All the codes from it can be seen in your macro list.

What’s the LOCATION of PERSONAL.XLSB Workbook

Here’s the bad news: Even though it’s such a useful thing to have, it’s not there in Excel by default, so you need to create it (I’ve shared the steps ahead in this post). But, you can check if it is already created or not.

The first method is to open your Visual Basic Editor and check if your Project window lists a file named “PERSONAL.XLSB”.

excel-create-personal.-xlsb-macro=workbook-open-vb-editor -to-check

That means it’s already there and there is no need to create it. The second method is to have a look at your XLSTART folder.

Note: If you put anything in the XLSTART folder, it will open automatically when you launch Excel. If you are using Windows 10 or 11 (replace Puneet Gogia with your user name):

C:\Users\Puneet Gogia\AppData\Roaming\Microsoft\Excel\XLSTART

to-create-personal-xlsb-macro-workbook-in-excel-startup-folder-windows

And if you are using MAC: Library⁩ ▸ ⁨Group Containers⁩ ▸ ⁨UBF8T346G9.Office⁩ ▸ ⁨User Content⁩ ▸ ⁨Startup⁩ ▸ ⁨Excel

To find the exact folder on your computer, open the VBA editor, press Ctrl + G to open the Immediate Window, type ?Application.StartupPath and press Enter.

excel-create-personal.-xlsb-macro-workbook-mac-location

If you aren’t able to find your Personal Macro Workbook using these methods then you need to follow the steps I’ve mentioned ahead to create a new one.

How to Create a Personal Macro Workbook in Excel

Creating a new personal macro workbook is simple. All you need to do is to record a macro, that’s it yes, that’s it.

Windows Version

Here are the simple steps you need to follow:

  • First of all, go to the Developer tab and click on the “Record Macro” button.
to-create-personal-xlsb-macro-workbook-in-excel-windows-go-to-developer-tab-and-click-on-record-macro
  • After that, in the “Record Macro” dialog box:
    1. Enter a name for the Macro
    2. In the “Store macro in” drop-down, select “Personal Macro Workbook”.
to-create-personal-xlsb-macro-workbook-in-excel-windows-select-from-drop-down

  • In the end, click OK.

Now you can record something or you can simply click on “Stop Recording”.

to-create-personal-xlsb-macro-workbook-in-excel-windows-stop-recording

Your new “Personal Macro Workbook” is created now. You can find the new PERSONAL.XLSB file in the XLSTART folder.

to-create-personal-xlsb-macro-workbook-in-excel-in-startup-folder

(MAC Version)

Below are the steps to create your Personal Macro Workbook in the MAC version of Excel.

  • First of all, go to the Developer tab and click on the “Record Macro” button.
to-create-personal-xlsb-macro-workbook-in-excel-mac-click-record-macro
  • After that, enter the name of the macro and select the “Personal Macro Workbook” from the drop-down.
to-create-personal-xlsb-macro-workbook-in-excel-mac-select-from-drop-down

  • In the end, click OK.

Now you can simply click on “Stop Recording” as your new personal macro workbook is created.

to-create-personal-xlsb-macro-workbook-in-excel-mac-stop-recording

Why Should I Have a Personal Macro Workbook?

This is the real question…

Well, if you love to use macros and have some useful codes which help you do your stuff with a click, you must have a Personal Macro Workbook. You can store all those codes in your personal workbook and can use them from any workbook on your system.

As I said, when you open Excel, “PERSONAL.XLSB” opens with it, so your codes will be accessible all the time when you are using Excel. So having it is a big WIN-WIN.

Can I Share My Personal Macro Workbook with Others?

It happens sometimes when you need to share your macros from Personal Macro Workbook with others or you just need to transfer it to a different system. Now in this situation, you can do the following things:

(A) Export and Import the Module

The best way to share or transfer your Personal Macro Workbook is to export the VB module from one system and import it into the other system. Below are the steps you can use to do this:

  • First, open the VB editor and expand the tree of “Personal.xlsb” and right-click on the module which you want to export.
  • Now, select the “Export File” option and save it on the desktop, and after that transfer it to the new system.
  • Next, you need to import this module into the VB editor on the new system.
  • For this, open VB editor and right click on the “Personal.xlsb” and select the “Import File”.

  • After that, browse the module file and click OK to import.

Now, you have the new module in your Personal Macro Workbook where you have all the VBA codes and you can use them from the macros list.

(B) Copy-Paste Personal.xlsb File to the Startup Folder

If the new system where you want to transfer all the codes doesn’t have a Personal Macro Workbook, then you can simply copy-paste personal.xlsb from the old system to the new system’s Excel startup folder.

Yes, that’s it.

Delete Personal Macro Workbook

If you don’t want to have a Personal Macro Workbook you can simply delete it from your system. All you need to do is close Excel, open the XLSTART folder and delete the file from there.

And if the PERSONAL.XLSB file is hidden in Windows, then you simply show hidden files and then delete it. The recommendation is to take a backup of the Personal Macro Workbook so that you can restore it in the future.

What if I’m Unable to Record a Macro in my Personal Macro Workbook

There can be a situation where you aren’t able to record a macro in Personal Macro Workbook. Or, it doesn’t open when you launch Excel.

In this situation, you need to check if your Personal Macro Workbook isn’t under “Disabled Items”. If it is, then you need to enable it. To open “Disabled Items”, go to File Tab ➜ Options ➜ Add-Ins ➜ Manage ➜ Disabled Items.

create-personal-xlsb-macro-workbook-in-excel-click-go

From this dialog box, you can simply enable it.

Hide it if Excel Keeps Opening it Every Time

As you know, every time you open Excel, the Personal.xlsb file opens with it automatically but sometimes instead of opening as a hidden file, it will open in the front.

Well, you can hide it again. All you need to do is make sure the PERSONAL.XLSB window is the active window, go to the View tab and click on “Hide”.

create-personal-xlsb-macro-workbook-in-excel-click-hide

Now, close Excel, and when it asks to save the changes to PERSONAL.XLSB, click Save, so it stays hidden. Restart Excel. That’s it.

Transfer Other VBA Codes in Personal Macro Workbook

It’s always better to record and write your macro code in Personal.xlsb, but you may also have code that you wrote before creating the PERSONAL MACRO WORKBOOK.

Moving it is simple. All you need to do is insert a new module in PERSONAL.XLSB and then paste all the code there. After that, save PERSONAL.XLSB from the VBA editor (Ctrl + S) so the code is kept.

Lock Personal.xlsb for Editing

If you want to lock your Personal Macro Workbook so that it can’t be edited, then you can simply follow the steps below:

  • First of all, go to the place where you have Personal.xlsb and right-click and open its properties.
  • After that, on the “General” tab, tick “Read-only” under Attributes.
create-personal-xlsb-macro-workbook-in-excel-tick-mark-read-only
  • In the end, click OK.

Once you do this, you can run the macros from it, but you can’t save a new macro in it.

Run a Macro from the Personal Macro Workbook

Go to Developer ➜ Macros (or press Alt + F8). The macros from your Personal Macro Workbook show up with the file name in front, like PERSONAL.XLSB!MyMacro, and you can run them in any open workbook. To make a macro one click away, add it to the Quick Access Toolbar from File ➜ Options ➜ Quick Access Toolbar ➜ Choose commands from ➜ Macros.

And to call one of these macros from the code of another workbook, use Application.Run:

Sub RunPersonalMacro()
Application.Run "PERSONAL.XLSB!MyMacro"
End Sub

Frequently Asked Questions

Why can’t I see my Personal Macro Workbook macros?

Either PERSONAL.XLSB didn’t open (check Disabled Items and the XLSTART folder), or the macro is Private or takes arguments, as the Macro dialog box only lists public macros without arguments.

Does the Personal Macro Workbook work in Excel for the web?

No. VBA macros don’t run in Excel for the web, so PERSONAL.XLSB only works in the desktop versions of Excel for Windows and Mac.

Do I need to save PERSONAL.XLSB as a macro-enabled file?

It’s already a binary workbook (.xlsb), which can hold macros. Just save it when Excel asks, after you add or change a macro in it.

In the end,

A Personal Macro Workbook can be helpful for you to manage all the important macros in one place. The best way to create a personal.xlsb is to simply record a macro in it. I hope this VBA tip will help you to ​Learn VBA, Faster.

But now, tell me one thing.

How do you Manage all the VBA codes you use?

Make sure to share your views with me in the comment section; I’d love to hear from you. And please, don’t forget to share this post with your friends; I am sure they will appreciate it.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

20 thoughts on “Personal Macro Workbook (personal.xlsb)”

  1. I have not learned how to manage my codes as yet as I am fairly new at VBA. Can record and ssave simple macros using the record function, but still learning.

    Reply
      • Hi Puneet,

        Thank you. This is helpful. I have created a code in PERSONAL.XLSB but when I am running the code in a newly open excel it still runs in the sheet which was open when I created this macro. Please can you advise what I am doing wrong?

        Reply
        • Check the references you have in the code… 😊

          Reply
  2. Thanks for a valuable introduction to the “PERSONAL.xlsb”

    I do not use it, instead keep all of my macros in a specific workbook.

    Can you please inform us of the best way for a User to backup this “All Important” “PERSONAL.xlsb” workbook ?

    Reply
  3. I too don’t use a PERSONAL.XLBS file. Keep all the codes in one module, Export it as BAS file and when required, import the same into the New works.

    This is where the “workbook” works in any machine with out any sharing

    Reply
  4. Thanks for the Mail and new tricks which you always share.
    I use my macro by making them as an ADD-In.

    Reply
  5. I don’t use a PERSONAL.XLBS file, though I must admit I don’t use too much VBA.

    For me, putting code (SUBs or FUNCTIONs) into a personal workbook means I may forget to transfer the required VBA code from it to the workbook I’m creating for others to use. Then things would fail when they tried to use it, a situation I try to avoid as much as possible.

    I can always go to one of the workbooks I’ve created and copy the code as & when I need it. Maybe in the future I’ll end up creating one, but haven’t had a need to .. yet.

    Reply
  6. Great presentation, Very useful for the up and coming Excel Gurus that are learning.

    Reply

Leave a Comment