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
Is it possible to attach a small sample ?
Sorry, no. It has company data.
Understood... Can you share the screen shot of the Actions ?
First screenshot is my SH1. It calls "SH08" which invokes a macro called "ResetDetailViewSel". This
macro is not being fired through these series of events. If I click directly on the tab for SH08, it works.
Maybe try this?
In SH1
First Action:- Button to activate the SH3
Second Action:- Run Macro
So you want me to run the macro from SH1?
Yes, try that?
I tested on my Macro but the macro which I have doesn't just get activated unless we click on it.
Is Macro specific for single sheet or all across dashboard?
The problem seems to occur only when the QV app is being executed from AccessPoint. In QV Designer
on the Windows desktop, it seems to be working fine. Why?
Check the reply from Peter
Qlikview Macro not working in Access Point
As he says, the VB Macros won't work on Ajax but may work on IE Plugin.
I guess you can change the plugin from QMC.
I don't know what effect it would happen if you change from Ajax to IE...
But many of the Macros fail to work in Access Point