Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have disabled the tabrows and used text objects (with actions) to move between the sheets. I would like the background colour of the objects to change when each sheet is active, as a visual indicator to the user. Please can someone offer help in a very basic and non technical way?
Thanks
Check enclosed file...
Hi Simon,
Suppose your sheet ID id is 'SH01'
Then in text box background color, write calculated expression as
=if(getActivesheetID()='SH01',Black(),white()).
Hope this will help you.
It should be...
something like below...
=IF(Wildmatch(GetActiveSheetId(),'*SH01*'),QlikTechGray(),Blue())
That has worked.
thanks very much for the help
Kindly close the thread by selecting appropriate answer...