Sheet show conditional not working

[#1]

Hi all,

I'm trying to hide a sheet based on a variable value. I assigned a dummy value in the conditional show input box and applied but the sheet still shows. It doesn't seem to matter what I put in the conditional input box, the sheet always shows. Is there a particular setting to be checked to enable conditional show sheet?

Thnx

Mat

[#2]

Hi Mat

There is nothing else to do, can you show me your condition?

[#3]

A value of 0 will hide the sheet. Any other value will display the sheet.

Perhaps try something like this..

=if(HideSheet = 'Yes',0,1)

[#4]

OK. Figured it out. Under Document Properties, Security, unchek Show All Sheets and Objects. I spent way too much time figuring this one out. Oh well....