Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I've tried but I can't seem to figure this out. I have a worksheet(1) in a workbook. On that worksheet I created button using the forms tool and associated it with a macro. It is th only control on the sheet and in the workbook. All is fine except... The button background color is grey and the lettering is black. Har to read. What I want to do is changed the button color. I thought could get at it with the shapes object but I can't figure out th syntax. Any help would be appreciated -- wrkoc ----------------------------------------------------------------------- wrkoch's Profile: http://www.excelforum.com/member.php...fo&userid=1006 View this thread: http://www.excelforum.com/showthread.php?threadid=26180 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you just want to change the background color, right-click on the button
and select 'Properties'. Choose the color on the 'BackColor' field. HTH Paul "wrkoch" wrote in message ... I've tried but I can't seem to figure this out. I have a worksheet(1) in a workbook. On that worksheet I created a button using the forms tool and associated it with a macro. It is the only control on the sheet and in the workbook. All is fine except... The button background color is grey and the lettering is black. Hard to read. What I want to do is changed the button color. I thought I could get at it with the shapes object but I can't figure out the syntax. Any help would be appreciated! -- wrkoch ------------------------------------------------------------------------ wrkoch's Profile: http://www.excelforum.com/member.php...o&userid=10064 View this thread: http://www.excelforum.com/showthread...hreadid=261806 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing background color | Excel Discussion (Misc queries) | |||
changing cell background color | Excel Worksheet Functions | |||
Changing background color based on different cell | Excel Discussion (Misc queries) | |||
background color showing only when in email form | Excel Discussion (Misc queries) | |||
Need help with Option Button dynamic background color | Excel Discussion (Misc queries) |