variables

[#1]

hi,

Can anyone explain me how to make the variable to set 1 or 0.

The main purpose of this set variable to 1 or 0 is, when i am setting the variable to 1 then it should minimize some objects in the Sheet (or) if i am setting the variable to 0 then it should minimize some other objects.

Can anyone help in this question

Thnks

[stephencredmond]

Add a button - Action = External, Set Variable, yourVar = 1

Add a 2nd button, sets yourVar = 0

Show/Hide the buttons based on the variable.

Regards,

Stephen

[lkallioniemi]

Hi,

if you want the variable to change value between 0 and 1, you can do it like this:

YourVariable=1-YourVariable

This will change the value 1 to 0 and value 0 to 1.

BR

Lasse