Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Alex,
in Property Document -> Security uncheck 'Show All Sheets and Objects'
Regards,
Antonio
Hi,
shouldn´t your variable vShowHideSheet be in the coditional field?
you Need to enter a condition
for instance 1=0 will hide the sheet
vShowHideSheet = 1 will Show the sheet if variable is 1
in "conditional" you must write:
vShowHideSheet <>0
let me know
Hi,
write below in your conditional field
vShowHideSheet=1
Regards
ASHFAQ
as I said, i have tried that. I doesn't work either
as I said, i have tried that. I doesn't work either
See new screenshots above
again, i your conditio field just write =vShowHideSheet . you don´t need =vShowHideSheet =1 or s.th. like that
doesn't work
doesn't work