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
Navigate to your Excel Options (File tab >> Options)
Click the Add-ins menu on the left-hand side of the dialog
In the Manage drop-down, select Disabled Items (last choice)
Select Personal Workbook and click Enable
Restart your Excel Application