Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one question on:
How to change the tab color when it is activated.
Can you help me out?
Thanks.
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())
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?
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())
Hi,
Find the attached file for tab color change
Use below syntex for dynamic current sheet id
=num(right(GetActiveSheetId(),2))
Hi,
here is a video that will demonstrate 8 different ways of achieving this
hope you find it useful!
you are very good programmer.
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
Hi Alan
Can you make a conclusion on which is the best approach in term of most simple ?
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
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.