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]

Make sure that no Add Ins have been disabled.

 

[Skyybot]

Also, try recording a new Macro and saving to PERSONAL.XLSB.

 

[Domenic]

Probably not your issue, but macros that contain one or more parameters will not appear in the macros list. For example, the following macro won't appear in the list because it contains the parameter x...

Sub Macro1(x as Long)

    'etc
   '
    '

end sub

 

[Skyybot]

Also...

Macros Disappearing Revisited

Hi, a while back my macros went away and were only visible in the VBA editor. Back then the solution for me was to log out of MS365 and relog in. Well today it happened again. Protected view and recompile did not work. What did work was opening excel then going to file > open > open and repair...

www.mrexcel.com

 

[571202]

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

Hi @Skyybot 'Trust access to the VBA project object model' wasn't ticked so I ticked it but it didn't fix the problem unfortunately, cheers

 

[571202]

Also...

Macros Disappearing Revisited

Hi, a while back my macros went away and were only visible in the VBA editor. Back then the solution for me was to log out of MS365 and relog in. Well today it happened again. Protected view and recompile did not work. What did work was opening excel then going to file > open > open and repair...

www.mrexcel.com

I have nothing disabled

 

[571202]

Probably not your issue, but macros that contain one or more parameters will not appear in the macros list. For example, the following macro won't appear in the list because it contains the parameter x...

Sub Macro1(x as Long)

    'etc
   '
    '

end sub

I have lots of macro that have been fine for years but have now suddenly disappeared, cheers