ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formatting buttons (https://www.excelbanter.com/excel-discussion-misc-queries/89871-formatting-buttons.html)

tdebb8594

formatting buttons
 

Is there a way to add color to the grey buttons created with the forms
toolbar?
I have several buttons on a sheet, each with it's own macro assigned
and I would like to make them look different.


--
tdebb8594
------------------------------------------------------------------------
tdebb8594's Profile: http://www.excelforum.com/member.php...o&userid=34668
View this thread: http://www.excelforum.com/showthread...hreadid=544341


Norman Jones

formatting buttons
 
Hi tdebb8594,

With forms buttons, only the font colour may be changed.

If you wish to use differently coloured buttons, try using buttons from thr
Control Toolbox instead.


---
Regards,
Norman



"tdebb8594" wrote
in message ...

Is there a way to add color to the grey buttons created with the forms
toolbar?
I have several buttons on a sheet, each with it's own macro assigned
and I would like to make them look different.


--
tdebb8594
------------------------------------------------------------------------
tdebb8594's Profile:
http://www.excelforum.com/member.php...o&userid=34668
View this thread: http://www.excelforum.com/showthread...hreadid=544341




penri0_0

formatting buttons
 

Hi,

If you have created a shortcut button for your macro in one of your
toolbars, right click the button and select Edit Button Image. It's
fairly straightforward from there.

Hope that helps


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=544341


[email protected]

formatting buttons
 
You could use an image for your button as well


tdebb8594

formatting buttons
 

What is the control toolbox?



Norman Jones Wrote:
Hi tdebb8594,

With forms buttons, only the font colour may be changed.

If you wish to use differently coloured buttons, try using buttons from
thr
Control Toolbox instead.


---
Regards,
Norman



"tdebb8594"
wrote
in message
...

Is there a way to add color to the grey buttons created with the

forms
toolbar?
I have several buttons on a sheet, each with it's own macro assigned
and I would like to make them look different.


--
tdebb8594

------------------------------------------------------------------------
tdebb8594's Profile:
http://www.excelforum.com/member.php...o&userid=34668
View this thread:

http://www.excelforum.com/showthread...hreadid=544341



--
tdebb8594
------------------------------------------------------------------------
tdebb8594's Profile: http://www.excelforum.com/member.php...o&userid=34668
View this thread: http://www.excelforum.com/showthread...hreadid=544341


Norman Jones

formatting buttons
 
Hi tdebb8594,

What is the control toolbox?


View | Toolbars | Control ToolBox

provides access to a number of activeX controls.

For more information on these controls, see ActiveX controls in Excel help.


---
Regards,
Norman


"tdebb8594" wrote
in message ...

What is the control toolbox?



Norman Jones Wrote:
Hi tdebb8594,

With forms buttons, only the font colour may be changed.

If you wish to use differently coloured buttons, try using buttons from
thr
Control Toolbox instead.


---
Regards,
Norman



"tdebb8594"
wrote
in message
...

Is there a way to add color to the grey buttons created with the

forms
toolbar?
I have several buttons on a sheet, each with it's own macro assigned
and I would like to make them look different.


--
tdebb8594

------------------------------------------------------------------------
tdebb8594's Profile:
http://www.excelforum.com/member.php...o&userid=34668
View this thread:

http://www.excelforum.com/showthread...hreadid=544341



--
tdebb8594
------------------------------------------------------------------------
tdebb8594's Profile:
http://www.excelforum.com/member.php...o&userid=34668
View this thread: http://www.excelforum.com/showthread...hreadid=544341





All times are GMT +1. The time now is 04:08 PM.

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