View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Filling a macro button with colour ( color)

If you mean command buttons from toolbox in Design mode(xl2003). Select the
button Right clickPropertiesBackColor...select a color

If this post helps click Yes
---------------
Jacob Skaria


"Chris Maddogz" wrote:

orry but after reading other post s on the same subject I have realised that
having created the buttons from the Forms Menu I can't change the colour etc.
However is there a way to use a button created via the Toolbox Menu to
utilise the same code that is assigned to one of my Forms Menu buttons or do
I need to start all over?

"Jacob Skaria" wrote:

If it is command button Right clickPropertiesBackColor...select a color (in
Design mode)
OR
If it is a autoshape like (rectangle) Right click Format AutoshapeColor
and Lines. Pick your color

If this post helps click Yes
---------------
Jacob Skaria


"Chris Maddogz" wrote:

I have a spreadsheet with 7 lovely macro buttons on it that automatically
execute lots of important jobs but look pretty boring in their basic
colouring ( coloring) and border formatting & I would like to change their
individual background colours ( colors) and bordering so as to make them more
appealing to the users.
Any help would be appreciated