My personal macro workbook is gone! Here's how to get it back (2024)

Where did it go!?

Man-oh-man, did that scare me the first time it happened!

One day I opened Excel and noticed that some of my favorite macros were not active when I used my keyboard shortcuts. What the hell was going on?

I then moved on to taking the next logical step and examining my VBA code. But there was one glaring problem, minePersonal.xlsbthe file was NOT in the VBA editor! I started to panic (but of course I was in the office, so it was an internal panic attack). Have all my favorite macros really just been deleted? I didn't back up anything and some took weeks to figure out! I was screwed!

Well, I'm here to tell you that there's a good chance they weren't deleted, because I later found out that my macros ended up being disabled during an Excel crash. The next section of this post details the steps I took to achieve thisPersonal.xlsbsave file and run again.

Steps to activate your personal macro workbook

1. Navigate to your ExcelPossibilities(Filtab >>Possibilities)
2. click onAdditionsmenu on the left side of the dialog box
3. I thinkControldrop down menu, selectDisabled items(last choice)
4. to electPersonal workbookone clickActivate
5. Restart your Excel application

Keep learning

Discover more →

TSG HQ - Setting up my home office

Today I'm going to give you behind-the-scenes access to all the gear I use here at TSG HQ (aka...

Best Online Excel and VBA Courses (2022)

Choices, choices and MORE choices! With so many educational options available on the Internet today, it can be overwhelming...

VBA code to measure the height and width of selected cell range in pixels

What this VBA macro code does Below is a simple VBA macro that I used to measure a group of cells...