x
...Sub Macro1(x as Long)
'etc
'
'
end sub
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, cheersTrusted Locations looks good. Have you allowed access to the VBA Project Model?
View attachment 94786
I have nothing disabledAlso...
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 lots of macro that have been fine for years but have now suddenly disappeared, cheersProbably 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 parameterx
...
VBA Code:Sub Macro1(x as Long) 'etc ' ' end sub