Tab Colors

[Legacy 319654]

I want to change the color of my tabs. I currently use 255 for red.

Sheets(*).Tab.Color =255

I want to change to a gray. Where are the color codes?

Thanks

 

[JoeMo]

The RGB function provides a spectrum of gray when its three arguments are identical in the range 1 to 255.

Example:

For i = 1 to sheets.Count
      Sheets(i).Tab.Color = RGB(1,1,1)
Next i

will produce the darkest gray while RGB(255,255,255) will yield the lightest gray.

 

[Legacy 319654]

Thank JoeMo!

 

[My Aswer Is This]

To get a RGB color you want without having to search the WWW for color chart do this:

1. Choose the fill color icon on the ribbon
2. Choose "More Colors"

3. Choose "Custom"
3a. Select the little box that says "New"

4. See the RGB buttons and scroll thru them you will see the color change in the small box on right.
5. When you get what you want use the RBG numbers you see in the boxes.


You should see how it works or click in the large Box at top on the color you like.

 

[JoeMo]

Thank JoeMo!

You are welcome - thanks for the reply.

Just for the record, I didn't word my response quite right. The RGB function's arguments are integers ranging from 0 through 255. RGB(0,0,0) is the color black, RGB(255,255,255) is the color white. The gray spectrum ranges from RGB(1,1,1) which is the darkest gray through RGB(254,254,254) which is the lightest gray.

 

[Legacy 319654]

My wife changed her mind and wanted a greenish.

[FONT=&quot]Tab.Color = RGB(51, 153, 102)[/FONT]