View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_3_] Peter T[_3_] is offline
external usenet poster
 
Posts: 81
Default 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

.