Can the sheet tabs be color coded?

Does anyone know a way that the worksheet tabs on a spreadsheet can be color
coded?

Right click on the tab name and select 'Tab Colour'

HTH

Giz

"Lynn" wrote:

> Does anyone know a way that the worksheet tabs on a spreadsheet can be color
> coded?

When I right click on the tab, I get the following:

Insert
Delete
Rename
Move or Copy
Select all Sheets
View Code

I have Excel 2000 - I don't know if that is the problem or not.

"Gizmo63" wrote:

> Right click on the tab name and select 'Tab Colour'
>
> HTH
>
> Giz
>
> "Lynn" wrote:
>
> > Does anyone know a way that the worksheet tabs on a spreadsheet can be color
> > coded?

Colored tabs were introduced in Excel 2002. They are not
supported in earlier versions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lynn" <Lynn@discussions.microsoft.com> wrote in message
news:7A8FBD2C-E790-41DF-A648-21E48FAC15EB@microsoft.com...
> When I right click on the tab, I get the following:
>
> Insert
> Delete
> Rename
> Move or Copy
> Select all Sheets
> View Code
>
> I have Excel 2000 - I don't know if that is the problem or not.
>
> "Gizmo63" wrote:
>
>> Right click on the tab name and select 'Tab Colour'
>>
>> HTH
>>
>> Giz
>>
>> "Lynn" wrote:
>>
>> > Does anyone know a way that the worksheet tabs on a
>> > spreadsheet can be color
>> > coded?

That's our difference.

I don't think it can be done in 2000. Can someone else confirm this?

"Lynn" wrote:

> When I right click on the tab, I get the following:
>
> Insert
> Delete
> Rename
> Move or Copy
> Select all Sheets
> View Code
>
> I have Excel 2000 - I don't know if that is the problem or not.
>
> "Gizmo63" wrote:
>
> > Right click on the tab name and select 'Tab Colour'
> >
> > HTH
> >
> > Giz
> >
> > "Lynn" wrote:
> >
> > > Does anyone know a way that the worksheet tabs on a spreadsheet can be color
> > > coded?