General discussion

  • Creator
    Topic
  • #2335295

    How can I change colors of sheet tabs?

    Locked

    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?

All Comments

  • Author
    Replies
    • #3577816

      How can I change colors of sheet tabs?

      by dklippert ·

      In reply to How can I change colors of sheet tabs?

      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.

    • #3603715

      How can I change colors of sheet tabs?

      by kjr1 ·

      In reply to How can I change colors of sheet tabs?

      This question was closed by the author

Viewing 1 reply thread