Conditional Show of Sheet

[#1]

Hi,

I was trying to Hide/Show a sheet based on the selection of a Field in a listbox(alternatestate)....looks like its not working

Condition Used: =if(Flag>0,'NO','YES')....it gives the right output in a text box,but when I use the same logic to conditionally show the sheet its not working.

if(Flag>0,1,0)

Any thoughts?

[hic]

Use

  =Flag>0

HIC

[sudeepkm]

you do not need to write if condition again in a conditional box. conditional box is designed to take the condition expression.

so if you are expecting to show the Sheet when Flag is non zero then you can just use Flag <> 0 in your Sheet's properties condition box

[#4]

Thanks for the prompt reply...it worked!!!