Hide a Tab

[anuradhaa]

I want to hide tab always and show it when i want.

Thanks

[#2]

u can use hide Tabrow property in Document properties..

[vikasmahajan]

Document Settiong -> Hide Tabrow

[anuradhaa]

I want to hide only one tab and not the tabrow

[Anil_Babu_Samineni]

Can you please confirm me which tab you want hide. I mean from Scripting / Sheet Tab...!

[vikasmahajan · Accepted solution]

This way you can give condition and hide one tab   formula  2 < 1 ( False) so tab will be hidden

[Anonymous]

Hi

Right click on the tab you want to hide and select properties.

Then on the general tab of the sheet properties box go to the show sheet section in the top left of the box and select the radio button for conditional. Finally enter the condition you want to use to show or hide your sheet and that will do it.

Kindest Regards

Brian

[PrashantSangle]

Hi,

go to sheet property > General > Conditional> write any condition which is never true like 1=2

Regards

[kristof_j]

Create a variable vShow with value 1

Then right click on a sheet background, go to 'Gerenal' and fill 'vShow' next to 'Conditional'

The sheet will hide the moment you change vShow to value 0

You can also create a button or a text object. Go to Actions, choose 'set variable' under 'External'

And then fill in the following expression

[susovan]

Hi Anuradha,

First of all go to the Sheet properties in which sheet you want to hide and than give the calculation condition.