1 Reply Latest reply: May 11, 2011 7:15 AM by Erich Shiino RSS

    Active Tab and inactive tab



      I want that the color of the tab change when the sheet is active.


      I know i can do it with a macro.


      is there anyone who can help me

        • Re: Active Tab and inactive tab
          Erich Shiino


          I create a simple trigger to change the value of a variable. (vTab)

          (sheet properties -> Trigger)


          I changed the tab color on sheet properties -> General

          -> tab settings -> Custom Colors

          -> I created an if statement to apply the color according to the value of this variable.


          I also created variables for the colors, so that you can set all of them in only on place.


          Please, check attachment.

          Hope it helps,