How to make my sheet auto display the report with out trigger initial select button ?

[paulyeo11]

Hi All

When i go to my invevntory report sheet , i need to click on the button to run the below script.

ActiveDocument.GetField("Pls select 1st Dim").Select "BRAND_INV_SUB"

Now i want to make this auto turn on when user go to this sheet.

May i know how to do it ?

Paul

[ariel_klien · Accepted solution]

Hi,

Go to Sheet Properties > Triggers > OnActivate Sheet  Add Action...

Hope this will help you,

BR

Ariel

[paulyeo11]

thank you very much ariel