Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to hide a particular Sheet from the tabrow , while keeping all the other sheets visible , even when i am this sheet i want it to be not visible in the tabrow
Hi,
In the Sheet properties >> General >> Show sheet >> Conditional >> =0
Or
Create a variable Let vDisplay = 0;
In the Sheet properties >> General >> Show sheet >> Conditional >> =$(vDisplay)
And aging if you want to change to display it then change the variable value to 1.
Regards
Anand
i am not able to view the sheet through navigation buttons
i have seven tabs
i want 6 of them always visible
on the 6th tab i have a button that moves me to the 7th tab
when i am on the 7th tab i want all the 6 tabs to visible in the tabrow but not the 7th tab
Means when you are in 7th sheet you want to ignore the Hide Tabrow properties.
Why not you create Seven Text box with the sheet activate actions and activate the Hide Tabrow properties
Ex:-
Regards
Anand