Trigger already created variable

[bobbydave]

I have 10 text boxes (that I use as buttons) that have variables on click will trigger and open charts on one sheet.

Variable:

vReport = 2.14

What I would like to do is when the sheet is opened, (activate sh01)

for it to open vReport = 2.14 also, rather than have to physically press the button for the conditional report to appear.

Can this be done?

[tamilarasu · Accepted solution]

Hi,

Follow the below steps.

Right click on the sheet -> Properties -> Triggers -> OnActivateSheet -> Add Actions -> External option -> Set Variable -> Type Variable as "vReport" (Without double quotes) -> Value as 2.14