Macros disappeared

[tonybr]

Hi

I've read through all the other responses to a query like this and none of the solutions seem to help me (unless I am doing something wrong).

I was working on a macro yesterday and since then, the macro list doesn't appear.

I can see them if I type F11 though. This is the macro I was working on when it broke.

The personal.xlsb file is in the expected location (916kb) and it's not disabled,
removed the offending module and it made no difference.

I then see the following messages. I'm not sure what that last one is asking me to do as it's already stored in C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART

Can anyone assist please? Thanks

 

[tonybr]

I tried again to delete the offending module and this time, the personal workbook saved and they're back.

 

[jkpieterse]

It might be a good idea to recreate your personal macro workbook as it sounds like it is close to becoming corrupt. Steps:

1. Close Excel
2. Copy your current personal.xlsb to elsewhere and rename it (Excel cannot open two files with the same name)
3. Open Excel, record a trivial macro to personal macro workbook
4. Close Excel, save the personal macro workbook
5. Reopen Excel, open the copy of the personal macro workbook
6. Drag all modules (and other stuff) from the copy to the new one
7. Close Excel, save the personal macro workbook.