Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot hide sheet

I have tried using a vShowHideSheet variable and setting the value to 0. I have also tried simply typing in 0, but i cannot hide any sheets on this document!

Both methods work on other documents i use.

Is there another setting which is over-riding this that i don't know about? Help, it's driving me mad!

hide.png

18 Replies
alexandros17
Partner - Champion III
Partner - Champion III

IN the box "conditional" you must write a condition so if you want that with 0 sheet disappear and with 1 reappear then write: vShowHideSheet=1

if your variable is 0 the sheet hides otherwise appear

michael_maeuser
Partner Ambassador
Partner Ambassador

did you really set you variable to 0?

ashfaq_haseeb
Champion III
Champion III

Hi,

Attach your sample app.

Regards

ASHFAQ

antoniotiman
Master III
Master III

Hi Alex,

in Property Document -> Security uncheck  'Show All Sheets and Objects'

Regards,

Antonio

michael_maeuser
Partner Ambassador
Partner Ambassador

can you share the app? if there´s confidential data, just scrumble it

Not applicable
Author

I have tried it with and without the = sign. neither works

equals sign.png

Not applicable
Author

variables.png

simondachstr
Luminary Alumni
Luminary Alumni

That's probably it.

Not applicable
Author

Thanks Antonio!!!

So simple