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

    Active Tab and inactive tab

      Hello

       

      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

          Hi,

          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,

           

          Erich