My Personal Macro Workbook Disappeared! How To Get It Back

How to Fix Personal Macro xlsb Disappeared

Man-oh-man did this freak me out the first time this happened!

One day I opened up Excel and noticed some of my favorite macros weren’t running when I used my keyboard shortcuts. What the heck was going on?

I then proceeded to take the next logical step and investigate my VBA code. But there was a glaring problem, my Personal.xlsb file was NOT in the VBA Editor! I start to freak out (but of course I was in the office, so it was an internal freak out). ! Did all my favorite macros really just get deleted? I didn’t back them up anywhere and some of them took weeks to figure out! I was screwed!

Well, I here to tell you there is a good chance they were not deleted as I later found out my macros ended up getting disabled during an Excel crash. The next section will share the steps I took to get the Personal.xlsb file up and running again.

Steps to Enable Your Personal Macro Workbook

  1. Navigate to your Excel Options (File tab >> Options)

  2. Click the Add-ins menu on the left-hand side of the dialog

  3. In the Manage drop-down, select Disabled Items (last choice)

  4. Select Personal Workbook and click Enable

  5. Restart your Excel Application