General discussion

Locked

How can I change colors of sheet tabs?

By KJR1 ·
I would like to assign individual background colors to each worksheet tab in an Excel 97 workbook. I know the tab color is linked to the Windows default colors. Is there a property for tab background color that I can set to be a color other than theWindows default for each tab? How would I handle the active/inactive state with the color changes?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How can I change colors of sheet tabs?

by DKlippert In reply to How can I change colors o ...

Sorry to have give a negative answer, but there was no way to change the color of the sheet tabs until Excel 2002.
People have been trying to find a way, but except for changing the default Windows colors there isn't anyway to do this.

Collapse -

How can I change colors of sheet tabs?

by KJR1 In reply to How can I change colors o ...

Poster rated this answer

Collapse -

How can I change colors of sheet tabs?

by KJR1 In reply to How can I change colors o ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums