Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Form Button Background Color
Yes I got it from the forms toolbar exactly because I need it to go wit the sheet and be copied with it. I suppose I could do some Vbscriptin to create a ControlBox button on the fly for each sheet and associat the macro with it but that sure sounds like more work than I want to g through. Excel help files imply that I can do this with shapes.fill. Is ther some way I can check this -- i.e. dump out the shapes collection so can see what's in it? Or am I just having fond hopes -- 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
|
|||
|
|||
Changing Form Button Background Color
Why not make your own button. In the Drawing toolbar, look
at Basic shapes Bevel (looks like a double rectangle), get rid of the lines, add some text, assign a macro. Format at will, be limited only by your imagination. Regards, Peter PS seem to be starting a lot of new threads here! -----Original Message----- Yes I got it from the forms toolbar exactly because I need it to go with the sheet and be copied with it. I suppose I could do some Vbscripting to create a ControlBox button on the fly for each sheet and associate the macro with it but that sure sounds like more work than I want to go through. Excel help files imply that I can do this with shapes.fill. Is there some way I can check this -- i.e. dump out the shapes collection so I can see what's in it? Or am I just having fond hopes? -- wrkoch ---------------------------------------------------------- -------------- wrkoch's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=10064 View this thread: http://www.excelforum.com/showthread...hreadid=261806 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing background color | Excel Discussion (Misc queries) | |||
changing cell background color | Excel Worksheet Functions | |||
background color showing only when in email form | Excel Discussion (Misc queries) | |||
Changing Form Button Background Color | Excel Programming | |||
Changing Form Button Background Color | Excel Programming |