Cant use or access macros in Personal.xlsb

by

After a sudden unplanned power trip on I am no longer able to access my macros or view their code in Visual basic for excel.

If I try to access it now it only displays a grey box displaying the name of the macro but no code.

I’ve copied and sent it to a peer who can access and use all my macros. I’ve tried to delete my copy and replace it with the one I sent him, but the problem still persists.
I’ve tried to repair the file but it doesn’t work.

Any help will be greatly appreciated as my last backups are from the beginning of November and don’t include several new files

enter image description here

  • If you press Alt+F8 can you see any of your macros? In the VBE try setting View >> Cascade in case your ode windows ended up off-screen.

    – 

  • nothing shows up when I use Alt+F8, I can see the actual code window its just blank and greyed out

    – 

  • Can you create a new macro in the workbook?

    – 

  • I cant make or edit any existing macros in the workbook. I can make macros in other workbooks but cant extract any of my already existing macros

    – 

  • Close all your Excel files and check in the Task Manager of the exist of any excel app.

    – 

Leave a Comment