Macro doesn't show up in list

[ValuationMan]

Hi All,

I'm having a really weird macro issue. Even though the modules are all present in my workbook, I do not see any of the macros in the list in Developer > Macros. Yes, I clicked "enable macros" when opening the file. No, I do not have any parameters in the macros. I have also tried removing all modules and adding them back. I have also tried creating a new module. None of it seems to work. Have any of you ever come across that before?

 

[jasonb75]

Are any of them named as Private Sub? Those don't show up on that list.
Events will not show up either (procedures that start automatically based on a specific action).

 

[ValuationMan]

None of them are private

 

[jasonb75]

Try a new workbook instead of just a new module, copy one of the missing procedures to the new workbook and see if it comes up on the list then.

 

[RoryA]

Try adding a reference, then debug-compile, then remove the new reference, and see if that helps?

 

[ValuationMan]

Try a new workbook instead of just a new module, copy one of the missing procedures to the new workbook and see if it comes up on the list then.

Doesn't come up. It's a very odd glitch. Never seen this before.

 

[jasonb75]

Have you tried Rory's suggestion?

 

[ValuationMan]

Thank you to both of you for your help. Rory's suggestion helped. I noticed VBE was holding onto a lot of the workbook references even after quitting Excel completely. Anytime I tried to debug-compile the workbook quit, which clued me into the workbook being corrupted. I ended up opening the file using Open and Repair and that fixed it.