Changing the macor button color

[LoveCandle]

Hi everybody,

Is there any program or code to change the macro button main color.

[Nick Hebb]

As far as I know, you can't.

Below is a link to a little article I wrote for fun. It describes how
to use Excel to make simple web graphics (buttons, in this case):

http://www.breezetree.com/article_excelbuttondesign.htm
(ignore all the broken links, - the site's still under construction)

Most of the article could be applicable to you if:
1. Your macro button is on the worksheet.
2. You assign a macro to the shape.

HTH,

Nick Hebb
BreezeTree Software
http://www.breezetree.com

[Leith Ross]

Hello LoveCandle,

The color is set internally by the object class. You can change it manually by using the object property object_name.BackColor. You can do it using code or do it from the Editor and changing the property on the Properties sheet.

Sincerely,
Leith Ross