Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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