Can you change the Sheet Tab Colour

[Guest]

Hello

Just wondering can you change the sheet tab colour as per Lotus 123? Is it possible from within Excel or any VBA solutions

Thank

Bria
Manchester, England

 

[Bob Phillips]

Hi Brian ,

You can with XL2002 and above but not earlier versions. It is just a
right-click option on the sheet tab name.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hello,

Just wondering can you change the sheet tab colour as per Lotus 123? Is it

possible from within Excel or any VBA solutions?

 

[Frank Kabel]

Hi
depending on your Excel version. This feature was introduced with Excel
2002 (or Excel 2000?). Right click on the tab name and there is a menu
for this ('tab color')
For versions prior to this: no chance

--
Regards
Frank Kabel
Frankfurt, Germany

Hello,

Just wondering can you change the sheet tab colour as per Lotus 123?

Is it possible from within Excel or any VBA solutions?

 

[Norman Harker]

Hi Racer!

For Excel 2002 and above right click the sheet tab.

For Versions below that level, you can't change the tab colour but you
can put classifiers on the tabs to group them:

eg

a1. 1999 Revenue
a2. 1999 Costs
a3. 1999 Summary
b1. 2000 Revenue
etc.

You can then sort the tabs manually or with a subroutine.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Hello,

Just wondering can you change the sheet tab colour as per Lotus 123?

Is it possible from within Excel or any VBA solutions?