Hide the sheet

[Anonymous]

Dear all

i try to hide the sheet so i use sheet properties --> general --> show sheet--> condition = 0 for hiding the sheet, but sheet in not getting hidden.

anything i need to change in the document setting ?

please guide me...

thanks in advance

sirajahamed S

[maleksafa]

i guess more of a math fact.

[jpenuliar]

Yeah, i agree on that.

But is there any way to programmatically show the object?

Maybe i should post it as a new discussion...

JP

[Peter_Cammaert]

You mean, like adding condition

vDebug = 1

to all worksheets, and adding a button that toggles the value of vDebug with expression

=if(vDebug=1, 0, 1)

Without a button, you can change the value of vDebug in Settings->Variable Overview.

More complex handling is possible, but that all depends on what you are trying to accomplish.

[maleksafa]

you can also go with user condition, using the OSUser() so that only you will be able to see this sheet.

[Anonymous]

Settings->Document Properties->Security->Show All Sheets and Objects has been cleared.

when i unchecked the option the sheet hidden ed

thanks for your support..