Change the Button Color

Hello everyone,

I wrote a macro to chage the button color (Forum button) when it is clicked.

The macro is as follow.

“Sheet1.Shapes(“Button 1″).TextFrame.Characters.Font.Colorindex=5”

This code works for windows excel but not mac version. I wonder if anyone knows how to modify it for mac? Thanks!




By: Yen Lee

Leave a Reply

Your email address will not be published. Required fields are marked *