Macro's have disappeared but are still in VBA

[Mr_Phil]

Hi, using Office 365. I have a workbook I am building and the macro I wrote isn't showing up in the view macros box. I've tried viewing by name and by "this workbook". The Personal workbook and all it's macros show up just fine. And, if I go to the VBA editor I can see (and run) the macro from there. I guess I don't know the right keywords because so far google hasn't been much help. Anyone else ever encounter this? Any advice on how to troubleshoot?

 

[MurrayF]

I had the same problem but the other solutions didn't work. However, I found that if I saved and closed the file on one computer, copied it to another computer then went view,macro,view macro, the macros had returned on the list. So I saved this file and closed it, then copied this new version to the original computer, and the macros again showed. I'm not sure what caused the problem in the first place.

 

[Mr_Phil]

I had the same problem but the other solutions didn't work. However, I found that if I saved and closed the file on one computer, copied it to another computer then went view,macro,view macro, the macros had returned on the list. So I saved this file and closed it, then copied this new version to the original computer, and the macros again showed. I'm not sure what caused the problem in the first place.

I will keep that in mind. Like a variant of the unplug it, count to 30, plug in different outlet that fixes my satellite receiver. Thank you!

 

[Whitestar127]

Hi, I'm having this issue right now and it's driving me crazy. I tried logging out and back into Office, but that didn't help. I saw the tip on copying files but I can't do that for every new file. Too much hassle.
Honestly, I'm almost terrified of every new update that arrives on my computer now (from my IT department). One day everything works fine, then suddenly...pooof! everything gone.

 

[Whitestar127]

Eh, how do I edit my post?
Anyway, I have the same exact settings as OP. Everything is allowed basically, regarding macros and such. I'm also using Office 365 Enterprise. All macros visible in the Visual Basic Editor but none when clicking Alt-F8.

 

[Mr_Phil]

Hi, I'm having this issue right now and it's driving me crazy. I tried logging out and back into Office, but that didn't help. I saw the tip on copying files but I can't do that for every new file. Too much hassle.
Honestly, I'm almost terrified of every new update that arrives on my computer now (from my IT department). One day everything works fine, then suddenly...pooof! everything gone.

Since then I have discovered that if you start excel, then go to file > open, select your file, at the bottom is a "tools" button. Click the down arrow on it and select open and repair. It will open and you'll get a dialog box. But, more often than not the issue is at least temporarily resolved.

 

[Whitestar127]

Since then I have discovered that if you start excel, then go to file > open, select your file, at the bottom is a "tools" button. Click the down arrow on it and select open and repair. It will open and you'll get a dialog box. But, more often than not the issue is at least temporarily resolved.

Thanks for the tip, but that didn't work for me unfortunately.
What I'm doing at the moment is copying over the macros I need to every new workbook I open. Bit of a hassle, but at least I can then run them from Alt-F8.

 

[Whitestar127]

An windows update was waiting for me when I came to work today. After installing and restarting everything was back to normal.
I think the MS Office + Windows monster has gotten so big now that nobody at Microsoft knows what's going on anymore.

 

[Whitestar127]

An windows update...

A windows update...

 

[SingularitysPoint]

I had this issue today. There's no obvious reason for it. This link worked a treat for me - basically what *Whitestar127 said about copying and pasting, except just adding a line and removing it forces a recompile.

Redirecting