ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the macor button color (https://www.excelbanter.com/excel-programming/344995-changing-macor-button-color.html)

LoveCandle[_4_]

Changing the macor button color
 

Hi everybody,

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


--
LoveCandle
------------------------------------------------------------------------
LoveCandle's Profile: http://www.excelforum.com/member.php...o&userid=28612
View this thread: http://www.excelforum.com/showthread...hreadid=483044


Nick Hebb

Changing the macor button color
 
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[_243_]

Changing the macor button color
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=483044



All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com