I can no longer run my subroutines

[Sparkle99]

Microsoft 365, in November I wrote some VBA code and have it running fine from a Command Button.
I've just re-opened the XLSM file and the macros are not visible and the button doesn't 'press'.
When I 'view code' I can see the routines are there all fine - nothing is lost - but why won't it run?
This is on my PC, I have Trust Centre options enabled, Trusted Locations set etc...
It WAS working fine. I can only assume a Windows or Office update has done something, but how can I re-enable my code?

 

[RoryA]

Do you have to enter Design mode to select the button as in that third picture, or is that what happens when you just click on it normally?

Also, can you run the macros from the macros dialog?

 

[Sparkle99]

Do you have to enter Design mode to select the button as in that third picture, or is that what happens when you just click on it normally?

Also, can you run the macros from the macros dialog?

Hi, thanks for the reply.
I can use designer mode - the button used to 'press in' but now is just a red block that does nothing when clicked.
I can run the code from the editor, but not from the Macros window as they don't show in there (might be because they are Private SUB's?)

 

[RoryA]

I can use designer mode - the button used to 'press in' but now is just a red block that does nothing when clicked

What I am asking is whether the button itself gets selected when you click on it without choosing design mode?

 

[Sparkle99]

What I am asking is whether the button itself gets selected when you click on it without choosing design mode?

Clicking the CommandButton Object (!) with Design mode off does nothing now. No animation. Previously, it used to depress like a button and run the routine. I'm thinking there's some new level of security/permission at play here.

 

[RoryA]

If you add a new activex button to the sheet, is it clickable?

 

[Sparkle99]

If you add a new activex button to the sheet, is it clickable?

Debugging all of this - or "faffing about" - seems to have solved it.
I can now add a new button and double-clicking it creates me a new code block...
Private Sub Verify2_Click()
End Sub

The existing buttons that weren't working or behaving like buttons are now working fine and running my code.

I realise now that Private routines don't appear in the Macro list, so this was a red-herring anyway.

Thanks for your help.