Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matbelli
Contributor
Contributor

How to make a macro works only in one sheet

i need to activate a macro only on some sheets.

Now it works as it should on one sheet and it has to stop on other sheets but even if i don't activate the macro in other sheet's property it keeps working. How can i block the macro's execution?

1 Reply
marcus_sommer

Often are macros not the best way to provide the users  good usability: Macros-are-Bad. Nevertheless if you want to keep them you need to adjust the macro-trigger or adding a check to the active sheet and using an if-contruct to branch between the executing the macro and doing nothing. Here an example from the APIGuide.qvw:

 IsActiveMacro.JPG

 - Marcus