Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 3 sheets (SH1, SH2, SH3) in a QV document. In SH1, I have a textbox (TB1) which
does this Actions -> Activate Sheet (SH3). On SH3, I have a trigger that does this
Triggers -> OnActivateSheet -> Run Macro -> ResetValues.
The problem I am having is that the macro (sub routine) called ResetValues is not being
fired. If I just open this QV document and click on tab3 which is SH3, this macro
gets executed.
Am I not doing this right? How do I fix this?
Thanks
Macros will not work in Ajax, You need to use IE and it will work.
Can you explain what Ajax means or difference between Ajax and IE?
How to change Ajax to IE Plug-in
Check above link....you can change it from QMC, if you've access to QMC.
OK, I did some reading on AJAX vs. IE Plugin. I still don't understand why the macro runs if I click on the tab
directly but not from another sheet where it does the ActivateSheet.
Are you accessing this dashboard from Access point ? If you are, and then you are saying when you click on the tab it is working but not from another sheet ?
Which plugin are you using IE or AJAX ?
