Colouring excel sheet tabs

N

NealUK

Just wondering if anyone knows of a way to colour the bottom tabs of an
excel worksheet. Is there a macro i can use to colour them?
Again, any help much appreciated
regards
Neal

--
 
G

Gord Dibben

Neal

Only in XL2002 and 2003

Versions prior to these have no method(macro or otherwise) of colouring sheet
tabs.

In XL2002 right-click on tab and "Tab Colour"

Gord Dibben Excel MVP
 
J

JTD

if you are using excel 2002 or later right click on the tab to edit
color. I don't think it can be done on earlier versions.
 
Top