Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OnOpen trigger does not allow to open document

Hi All,

I have created a macro and put in to the OnOpen trigger.

When I open document it hungs up, and nothing can be done with it.

Maybe you know how to disable document triggers before it is opened?

I believe there is a trick 🙂

Kind regards,

Janusz

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP


Janusz Twardziak wrote:I believe there is a trick


Hold down the Shift and Ctl keys while open the document. That will suppress the OnOpen trigger.

-Rob

View solution in original post

3 Replies
Not applicable
Author

maybe you can try ActiveDocument.Application.WaitForIdle which holds macro execution until qlikview has finished refreshing itself

Not applicable
Author

Thanks for your response.

I've tried your suggestion but still document is "locked".

Kind regards,

Janusz

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP


Janusz Twardziak wrote:I believe there is a trick


Hold down the Shift and Ctl keys while open the document. That will suppress the OnOpen trigger.

-Rob