How to change the tab color when it is activated.

[#1]

Hi All,

I have one question on:

How to change the tab color when it is activated.

Can you help me out?

Thanks.

[#2]

Hi vishwaranjan,

Thanks for your quick reply, what I meant is I want to let all activated sheet tab with red, for unActivated one with black.

How to do it?

[er_mohit · Accepted solution]

see the attached file

try this

in custom tab color of sheet pr0perties then write below code in calculated

if(GetActiveSheetId()='Document\SH01',red(),Black())

[kumarnatarajan]

Hi,

Find the attached file for tab color change

Use below syntex for dynamic current sheet id

=num(right(GetActiveSheetId(),2))  

[rustyfishbones]

Hi,

here is a video that will demonstrate 8 different ways of achieving this

http://youtu.be/g1vIwNx8DMQ

hope you find it useful!

[paulyeo11]

you are very good programmer.

[rustyfishbones]

here is another way that's not in the video

IF(MID(GetActiveSheetId(),10,4) ='SH01',GREEN())

MID will always start at 10 for GetActiveSheetId() if you want to return the Sheet number

Document/SH01, Therefore the above Expression will give SH01

[paulyeo11]

Hi Alan

Can you make a conclusion on which is the best approach in term of most simple ?

[rustyfishbones]

I would say using the RIGHT function is most simple

IF(RIGHT(GetActiveSheetId(),4)='SH01',GREEN())

I only say that because it's a function used in lot's of different Applications and would be well know to most beginners

Regards

Alan

[Alexander_Thor]

I might add that if a user creates a sheet it wont get the document prefix so the right() approach solves that kinda nicely. What bugs me though is that I haven't been able to figure out a totally dynamic expression that don't forces me to hard code the sheet id.