How to make a macro works only in one sheet

[matbelli]

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?

[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:

 

 - Marcus