Restore Deleted Macros and the Use of PERSONAL Macros

Anonymous
2023-05-10T15:08:23+00:00

In Excel, I tried to delete a macro I created, but messed up on. It gave me an error saying I had to unhide the workbook. I did something (can't remember what) and then it worked. However, when I deleted 1 of my 5 macros, it deleted all of them. It also disabled my ability to use or see or even create new macros in "Person View."

How do I get my macros back and restore my PERSONAL.XLSB macros?

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2023-05-10T15:55:11+00:00

Hi Michelle C!

It's possible that when you deleted the macro, you accidentally deleted the entire module that contained all of your macros. This would explain why all of your macros disappeared.

To restore your macros, you can try the following steps: * Open a new Excel workbook. * Press ALT + F11 to open the VBA Editor. * In the VBA Editor, go to File > Import File. * Browse to the location of your "PERSONAL. XLSB" file (usually located in C:\Users\username\AppData\Local\Microsoft\Excel\XLStart), and select it. * In the "Import File" dialog box, select the "Module" option, and click OK. * In the "Import" dialog box, make sure that the "Module1" option is selected, and click OK. Your macros should now be restored.

If this doesn't work, you can try restoring a backup copy of your "PERSONAL. XLSB" file. To do this, you can try the following steps: * Close Excel. * Go to the location of your "PERSONAL. XLSB" file (usually located in C:\Users\username\AppData\Local\Microsoft\Excel\XLStart). * Look for a backup copy of the file, which should have a similar name but with a different extension (e.g., "PERSONAL. XLSB.bak"). * Rename the backup file to "PERSONAL. XLSB". * Open Excel and your macros should now be restored.

If neither of these solutions works, you may need to recreate your macros from scratch.

Best Regards, Shakiru

Was this answer helpful?

4 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2023-05-10T16:11:24+00:00

Hi Michelle C!

You are most welcome.

Please, remember to give back to the community. Help the next person with this problem by rating and indicating if this conversation was helpful. Thank you

Best Regards

Was this answer helpful?

2 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-28T00:34:42+00:00

    PERSONAL. XLSB couldn't be found on my computer . reason?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-05-10T16:08:02+00:00

    That worked! Thank you so so much!! You are an Excel-Life saver. :D

    Was this answer helpful?

    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-05-10T15:46:52+00:00

    How do I get my macros back and restore my PERSONAL.XLSB macros?

    From your backup... if you have one.

    Andreas.

    Was this answer helpful?

    0 comments