Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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