Colouring excel sheet tabs

[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

--

 

[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

 

[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.