More Colors

[R1chard]

On Excel you have a total of 40 colors to choose from. Is there anyway in which you can select different colors? as the colors you can choose from are abit plain and boring?

Bit of a stupid question but you never know unless you ask!

 

[pcc]

check Help on 'RGB'
you can have >16 million (256^3)

 

[R1chard]

Also can you change the color of a button because they always default to grey!

 

[pcc]

Depends on type of button.
If from Controls toolbox - yes
If from Forms toolbar - No

(as far as I am aware)

 

[takformaten]

Sure you can, right click on the Button in design mode, go to Properties, go to Back color. Open the drop down list and in palette you find a variety of colours to choose from.

In the properties menue you can also ad pictures as background to your button, which gives you a neverending set of options!

Hope that helps

Tak!

 

[R1chard]

i dont understand! What do you mean by Design Mode? When i right click my button the optios i have are Cut, Copy, Paste, Edit Text, Grouping, Order, Assign Macro and Fromat Control. The only one of them options which allows me to edit the button is Fromat Control, and there i can not change anything but the size!

 

[pcc]

That's because your button is from the Forms toolbar.
To do what Takformaten suggests, you need to use one from the Control toolbox.

 

[takformaten]

In View / Toolbars you can add the Control Toolbox.

Here you find a button with a triangular shape, a ruler and a pencil. Click it and you change to "Design mode", which allows you to select a VButton by clicking on it, instead of activating a VButton by clicking on it.

You got the properties button, which brings you directly to the properties of anything you have selected on the active worksheet, the "view code" button, which swaps between VB and Excel mode and various different sets of boxes and lists to drag into the sheet.

Pretty helpful toolbar...

 

[R1chard]

Thanks Alot

 

[Greg Truby]

FWIW - You actually have 56 colors to pick from. You'll see 40 on the standard toolbar color pallet tools. But if you use Format | Cells... (or Ctrl+1) on the Patterns tab you'll see the other 16 you can pick from.

Also, you can go into Tools | Options... and pick the Color tab and customize your workbook's color scheme to your heart's content.