onLeaveSheet

[#1]

Hi,

I'm creating a sheet in which I want only a few people to access. What I have done is created a variable and set to 0.
Set a calculation condition on the hidden sheet to be 1, so when you open the document the sheet isn't there.
I then created a transparent button on a visible sheet to change the variable to 1 so the sheet appears and i added a trigger for onLeaveSheet -Set Variable to 0 so when I leave the sheet, the sheet should disappear but it doesn't.

Can anyone tell me what I am doing wrong here?

Thanks in advance,
mckay9999

[#2]

Hi

don´t you need to put a "save document" somewhere?

if you are using Version 9 you could create an exit button setting the var to 0, saving the document and then closing it.

Cheers

Adriano