Active Tab and inactive tab

[#1]

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

[erichshiino · Accepted solution]

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