Change Color of a group of Command Buttons

[Leigho]

I have a worksheet with 28 ActiveX command buttons. When a button is clicked, its macro performs an action and changes that button's backcolour. I need to create a macro to reset all buttons to their original pale grey color. Is there a way to do this without using 28 lines of code to change each one individually?

[JEC.]

Please Login or Register  to view this content.

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M



P. S. Your project must include a reference to the "Microsoft Forms n.n Object Library".

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated!

Best regards,

Greg M