How to make a macro works only in one sheet

matbelli — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: How to make a macro works only in one sheet

marcus_sommer — Mon, 14 Jan 2019 12:00:10 GMT

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:

- Marcus

topic Re: How to make a macro works only in one sheet in QlikView

How to make a macro works only in one sheet

Re: How to make a macro works only in one sheet