Active Tab and inactive tab

Wed, 11 May 2011 10:14:07 GMT

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

erichshiino — Wed, 11 May 2011 11:15:24 GMT

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