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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Alex,

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

Regards,

Antonio

View solution in original post

18 Replies
michael_maeuser
Partner Ambassador
Partner Ambassador

Hi,

shouldn´t your variable vShowHideSheet be in the coditional field?

Anonymous
Not applicable
Author

you Need to enter a condition

for instance 1=0 will hide the sheet

vShowHideSheet = 1 will Show the sheet if variable is 1

alexandros17
Partner - Champion III
Partner - Champion III

in "conditional" you must write:

vShowHideSheet <>0


let me know

ashfaq_haseeb
Champion III
Champion III

Hi,

write below in your conditional field

vShowHideSheet=1


Regards

ASHFAQ

Not applicable
Author

as I said, i have tried that. I doesn't work eitherhide2.png

variables.png

Not applicable
Author

as I said, i have tried that. I doesn't work either


See new screenshots above

michael_maeuser
Partner Ambassador
Partner Ambassador

again, i your conditio field just write =vShowHideSheet . you don´t need =vShowHideSheet =1 or s.th. like that

Not applicable
Author

doesn't work

Not applicable
Author

doesn't work