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

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

.