Changing Form Button Background Color

[wrkoch]

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

 

[Peter T]

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!