Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to remove green dots from tabs.
How can we do it? and donot want to go for buttons.
Please help.
Thanks in advance.
Hi,
you can set up a 'Clear All' action on tab activation, I guess. If you right click the tab, go into Sheet Properties and then into Triggers. Hope this helps.
rgds
Artur
Hide your tabrow and go for text objects to show the sheets
like
Start page Portfolio Projections ...... and so on
and use hyper links to go to sheet
Hope this helps
Green dots symbolize selection in that tab.
Do you want the green dots to be unavailable when the document opens?
If so, then you can use the "OnOpen" document trigger to clear all the selections.
Otherwise you can hide the tabrow and use text objects then give actions on them to show the sheets as suggested by Anand.
I donot want use buttons or variables for this.
Actually in my requirement, in some of the sheets some values in list boxes will be always one selected. so even if i clear all but it will display.
Hi Akansha,
Find Sample application in attachment.
--Jai
Hi,
so if this is always selected could you remove the listboxes showing that item from allthose tabs with green dots? This would help.
Rgds,
Artur
No, I cannot remove as they are required there. Infact, because of the requirement i have intentionally kept it there.
So i do not see any other option apart from what the other guys suggested. You can only switch off selection indicators in tables but not in tabrow, unfortunately. Maybe that's an idea to consider by Qliktech??
Good luck,
Artur