Excel 365 macros disappeared...

[sadams1]

OK...I've read hours online about this nightmare & here's what I've done & found out...

1) going to View > Macros...suddenly shows nothing
2) adding the "Developer" then going to "Visual Basic"...all macros are visible

How in God's name can this be fixed.
I've exported all modules & can't even import the dumb things

3) have gone through all "options" to make sure macros are enabled
4) nothing is disabled

 

[Dan_W]

This can perhaps be explained by the type of procedures you have in your workbook and whether or not they require arguments. As an example:

Here you can see that I have 4 functions and 2 subs, but only 1 of them appears in the View Macros Window.
Why? Functions won't appear in the Macro View window at all, and subroutines will only appear if they do not require an argument. Subroutines located in userforms or class modules will not be listed here, neither will any subroutines located in a module marked with Option Private Module. Which leaves standard modules and worksheets. Hopefully one of these applies to your circumstances - it may be worth putting a small subroutine in a standard module and checking. Say:

Sub Test()
MsgBox "Hello World!"
End Sub

Did that work?

 

[sadams1]

hello Dan, there were almost 20 macros & none required input. Several were started with keyboard shortcuts. This is just baffling.

 

[sadams1]

meant to emphasize that macros can't be made...I record something & it doesn't show in the window.

 

[Dan_W]

And when you're recording these macros,

or when you're looking for them, you have the correct workbook setting?

They're not being saved in a different workbook, or your Personal.XLSB?

 

[Dan_W]

Also - did you try the test code I suggested? See if it appears?

 

[sadams1]

Correct...followed those steps. To add to the bizarreness, I have a recent copy of the workbook (with the macros) so I opened it along with the current version (now missing the macros) & the keyboard shortcuts I use the start the macros work in the current version but do not show in the macro window. Also, I have never messed with or even know where the "personal.xlsb" file is. I read about this as well.

 

[sadams1]

so you don't think I'm crazy...
1st is screenshot from "View > Macros"
2nd from "Developer > VBA" (all Modules visible in both [folder not expanded])

 

[RoryA]

I've exported all modules & can't even import the dumb things

What happens when you try to import them?

 

[sadams1]

This is what's really confusing...using the "Developer > VBA" path, since the modules are visible, there's nothing to import. Using the "View > Macros" path, there's no active option to do anything since the window is blank.