Discussion Locked

How can I change colors of sheet tabs?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by dklippert

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.

This discussion is closed to new replies.