Personal VBA macros disappeared

[571202]

Hi, my macros are still working and in my Personal file but are not in the below box, not in any of the drop downs ie Personal.xlsb, How do I get them back. Thanks in advance.

 

[Skyybot]

Apologies for this dumb question....have you tried restarting Excel?

 

[571202]

Yes

 

[Skyybot]

Is the PERSONAL.XLSB visible in the VBA Project?

 

[LazyBug]

Look at the beginning of the modules to see if there is a line

Option Private Module

 

[571202]

Is the PERSONAL.XLSB visible in the VBA Project?

Yes, they are all there and working OK

 

[571202]

Look at the beginning of the modules to see if there is a line

Option Private Module

No none of my macros have that

 

[Skyybot]

I found this:

Redirecting

answers.microsoft.com

 

[571202]

I found this:

Redirecting

answers.microsoft.com

Hi Skyybot, is everything OK in mine, see below

 

[Skyybot]

Trusted Locations looks good. Have you allowed access to the VBA Project Model?