| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling a macro button with colour ( color)
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filling a macro button with colour ( color)
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filling a macro button with colour ( color)
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filling a macro button with colour ( color)
Assuming your Forms buttons had macros assigned to them and these macros
live in a general module................ When you create the ActiveX button right-click and "View Code". A sheet module will open with these lines Private Sub CommandButton1_Click() End Sub Place a macro name between the lines like so............ Private Sub CommandButton1_Click() macroname End Sub Gord Dibben MS Excel MVP On Thu, 21 May 2009 02:58:01 -0700, 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filling a macro button with colour ( color)
Brilliant suggestion using the autoshape, exactly the solution I needed.
On Thursday, May 21, 2009 at 2:57:01 AM UTC-5, 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling colour in drop down options | Excel Discussion (Misc queries) | |||
| Help with filling cells with colour | Excel Discussion (Misc queries) | |||
| Change Macro Button Color 2007 | Excel Discussion (Misc queries) | |||
| cell auto filling with colour | Excel Discussion (Misc queries) | |||
| Macro button colour change??? | Excel Worksheet Functions | |||
Linear Mode
