Macro not being fired

[Anonymous]

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

[trdandamudi]

Is it possible to attach a small sample ?

[Anonymous]

Sorry, no.  It has company data.

[trdandamudi]

Understood... Can you share the screen shot of the Actions ?

[Anonymous]

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.

[MK9885]

Maybe try this?

In SH1

      First Action:- Button to activate the SH3

     Second Action:- Run Macro

[Anonymous]

So you want me to run the macro from SH1?

[MK9885]

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?

[Anonymous]

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?

[MK9885]

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