Worksheet Tab Colour

[MGumbrell]

Is it possible to change the colour of the tabs on a worksheet. If it is I would be grateful if you would let me know how.

Regards, Matt

 

[qafself]

Yes, matt, it's easy.

Just right click on the tab and in the box select tab colour and off you go!

Ed

 

[shades]

As long as you have XL 2002 or 2003. Otherwise you need VBA code.
________
Easy vape vaporizer

 

[HaHoBe]

Hi, shades,

Otherwise you need VBA code.

Could you please post some sniplets to work in Windows for XL8 and/or XL9?

TIA,
Holger

 

[MGumbrell]

Thanks guys.

I don't have XL 2002 or 2003 so I would be very gratefulif you could tell me how to do it in VBA.

Many Thanks, Matt

 

[shades]

This is rather extreme, and it will change the system colors. So be warned!

Change Tab Color in XL97 and XL 2000

Not recommended!
________
Vaporizer Volcano

 

[MGumbrell]

I will take the warning and not use it, but many thanks anyway.

Regards, Matt

 

[HaHoBe]

Hi, shades,

thanks for the link. Anyway I don´t come from from Lotus but had used Quattro Pro since the early beginnings in DOS with Borland - and that spreadsheet application featured coloured tabs from the very early (don´t remember if version 1.0 already featured it) Windows versions. Not to notice that version 2000 had some features that are due to come with Excel 12 - no comment if these are really necessary features (I really don´t think so as I haven´t handled files of that categories with a spreadsheet by now: I´d prefer a DBMS).

Ciao,
Holger

 

[shades]

I have mixed reaction to Excel 12.

1,000,000 rows and 64,000 columns. Might be okay, but just give people the idea it can become a database.

The ribbon is less customizable than current toolbar approach, which I find frustrating. I began on the Mac, and still use the Mac at home (OS X with Office 2004), which has been highly customizable. But I customize both my Windows version (at work) and my Mac version.

The improvements in Pivot Tables will be welcome.

VBA will be critical from my standpoint, since the Mac version still is based on VB5 (essentially XL 97 equivalent). There are many things that I can do at work in VBA that cannot be done on the Mac (some can be done with AppleScript).

And the list goes on....
________
Ultra Engine