set a variable when sheet is active

[#1]

Hi experts.

I need set a variabe when the sheet is active for example I have te variable CAL with tree values M1,M2,M3

and I need by default M1, of cours permited selects the other values but when change the tab or open the

report by default in M1.

any idea?

best regards.

[JonnyPoole · Accepted solution]

The sheets have an 'on activate' trigger and a 'on leave' trigger.

When users activate the sheet, you can use a 'set variable' action to set the variable.

When they leave you use the same action to alter the same variable accordingly.

The triggers are on the sheet properties / triggers tab.

[m_woolf]

Set an OnActivate trigger for each sheet that assigns the variable value

[#4]

thanks a lot Friends.