OnActivate Sheet Triggers are not working

[#1]

Hello,

I have an issue with sheet triggers in a document I'm working on. Selecting a sheet will execute the OnAtivate trigger but if the sheet is activated from a text box trigger, the sheet (which is conditionally hidden) will show but the Onactivate triggers are not working.

It was working before. I undid recent changes I made but it still does not work. Is there a document stetting that is effecting the triggers?

Thanks in advance!

[iktrayanov]

Visualize your variable to make sure it is set to 'sh02'

[#3]

Activate sheet is the last action on your triggers list?

[#4]

I've tried both. I have copied 2 of the sheets to a new QVW file, added the same variables and OnActivate triggers and it works. So it must be something with the document.

[#5]

The variable is set to sh02

[#6]

is there way you can attach the document?

[#7]

No unfortunately I can't it's a 35 sheet document with confidential client data.

[iktrayanov]

I created a test document and what seems to work is as Sudheer suggested promote Set Variable to be executed before Activate Sheet. I yo live is as is Sheet1 is showing but is not active hence no OnActivate triggers are fired.

[#9]

I already tried putting the set variable before the activate sheet and it does not work.

[iktrayanov]

Can you show me the OnActivate Sheet triggers that are not working for sh02.

[#11]

There are 5 variables that set to 'Active' or 'Inactive' which show specific buttons.

All the triggers on all sheets work when the sheets are not hidden (Ctrl+Shift+S). I have not changed anything on the 35 sheets and navigation buttons from when they were working a few hours ago. Everything stopped working when I tried to add a document field trigger.