Personal Workbook Rties to Open Again

Home ➜ VBA ➜ Personal Macro Workbook (personal.xlsb)

If you apply 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 y'all need.

But the question is, what's the best identify for this? PERSONAL MACRO WORKBOOK. Yes, that PERSONAL.XLBS workbook. Here'southward the crazy thing:

Creating a personal macro workbook and storing all the important macros in information technology can salvage yous a ton of time and help you apply them in all Excel files.

Isn't that Awesome?? And today in this post, I'll exist sharing with you everything you need to know about this file. So stay with me for the side by side 3 to 4 minutes.

What is PERSONAL MACRO WORKBOOK

Personal Macro Workbook is a file which tin be the common storage identify to store your all macros and use them. Although it's a subconscious file which opens when you start Excel in your arrangement. And y'all don't demand to open it separately when you want to access whatsoever of the codes from information technology. All the codes from it tin can be seen in your macro list.

What'southward the LOCATION of PERSONAL.XLSB Workbook

Hither's the bad news: Fifty-fifty though it's such a useful matter to have, it's not there in Excel by default , and so you lot demand to create information technology (I've shared the steps alee in this postal service). But, you can check if it is already created or not.

The get-go method is to open your visual basic editor and if your project window you accept listed a "PERSONAL.XLBS" named file.

That means information technology'due south already there and there is no need to create it. The 2d method is to take a look at your XLSTART folder.

Note: If you put annihilation affair in the XLSTART folder that will open automatically when you launch Excel. If you are using Windows ten:

C:Users\Puneet Gogia\AppData\Roaming\MicrosoftExcel\XLSTART

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

If y'all aren't able to notice your Personal Macro Workbook using these methods and then you lot need to follow the steps I've mentioned ahead to create a new i.

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'south it yes, that's it.

Windows Version

Here are the unproblematic steps you demand to follow:

First of all, get to the developer tab and click on the "Record Macros" button.

Afterwards that, in the "Tape Macro" dialog box:
1. Enter a name for the Macro
2. In the "Store macro in", drib down select "Personal Dialog Box".

In the end, click OK.

Now you lot tin can record something or you can simply click on "Finish Recording".

Your new "Personal Macro Workbook" created at present. You tin find the new PERSONAL.XLSB file in the XLSTART folder.

(MAC Version)

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

First of all, get to the developer tab and click on the "Record Macro Button".

After that, enter the proper noun of the macro and select the "Personal Macro Workbook" from the drop-down.

In the end, click OK.

At present you can simply click on "Stop Recording" as your new personal macro workbook is created.

Why Should I have a Personal Macro Workbook?

This is the existent question…

Well, if you love to apply macros and have some useful codes which help you lot practice your stuff with a click you must take a Personal Macro Workbook. Y'all can store all those codes your personal workbook and tin can use them from whatever workbook on your system.

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

It happens sometimes when you demand to share your macros from Personal Macro Workbook with others or you just need to transfer information technology to a dissimilar organization. Now in this situation, you tin can use do the post-obit things:

(A) Export and Import the Module

The all-time way to share or transfer your Personal Macro Workbook is to export the VB module from one system and import information technology in the other system. Below are the steps you can use to do this:

Beginning, open the VB editor and expand the tree of "Personal.xlsb" and correct click on the module which you want to export.
Now, select the "Export File" choice and save it at the desktop and after that transfer it to the new arrangement.
Next, you need to import this module non the VB editor at the new organization.
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.

At present, you lot have the new module in your Personal Macro Workbook where you lot have all the VBA codes and you can use them from the macros listing.

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

If the new arrangement where y'all want to transfer all the codes don't have a Personal Macro Workbook and so you tin can but copy-paste personal.xlsb from the old arrangement to new system's Excel startup folder.

Yes, that'due south it.

Delete Personal Macro Workbook

If y'all don't want to have a Personal Macro Workbook you tin can simply delete information technology from your system. All yous need to do is, open the Excel STARTUP binder and delete the file from there.

And if the PERSONAL.XLSB file subconscious then you simply unhide it and then delete it. The recommendation is to take a back of the Personal Macro Workbook so that you lot tin restore information technology in future.

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

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

In this situation, you demand to bank check if your Personal Macro Workbook isn't under "Disabled Items". If it is, then yous demand to enable information technology. To open "Disabled Items", go to File Tab ➜ Options ➜ Add-Ins ➜ Manage ➜ Disabled Items.

From this dialog box, y'all can but enable it.

Hide information technology if Excel Keep Opening it Every time

As you lot know, every fourth dimension you open Excel, the Personal.xlsb file opens with it automatically but sometimes instead of open as a hidden file it will open up in the forepart.

Well, you can make it hide back. All you demand to exercise is when you open your Excel app go to the View Tab and click on the "Hide" and select the "Personal".

In the terminate, click OK. At present, close the Excel and restart it. That'southward it.

Transfer Other VBA Codes in Personal Macro Workbook

It'south e'er better to record and write your macro code in Personal.xlsb, but for all the lawmaking which you have before creating the PERSONAL MACRO WORKBOOK.

This thing is uncomplicated. All you demand to exercise is create a new module and and then paste all the code there.

Lock Personal.xlsb for Editing

If you want to make your Personal Macro Workbook locked so that it tin't be edited then you tin simply follow beneath steps:

First of all, go to the identify where you have Personal.xlsb and right click and open its backdrop.
Subsequently that, from the "Security" tab tick mark the "Read Merely".

In the end, click OK.

Once y'all practice this, y'all can exist able to read macro from it just can't able to relieve a new macro in it.

In the Stop,

A Personal Macro Workbook tin can be helpful for you to manage all the important macros in ane identify. The best way is to create a personal.xlsb is to simply record a macro in information technology. I promise you found this VBA tip will help you to Learn VBA, Faster .

Only now, tell me 1 matter.

How 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 lot and please, don't forget to share this post with your friends, I am sure they will appreciate it.

Bosisto Untook52