topic Re: Macro doesn't work in QlikView

Macro doesn't work

Ayoub — Wed, 27 Nov 2019 13:14:12 GMT

Hello community,

i added a macro which allows me to fit zoom to the window. it's a popular macro .. i used it in the triggers of sheet properties for every one sheet .. so when the sheet been activated then the macro exectued.

this is the problem , the macro doesn't execute when i activate the sheet. it's executed when i'm switching beetwen them.

i did my beest to solve the problem but i didn't reach the solution .

thank u

Re: Macro doesn't work

Miguel_Angel_Baeyens — Wed, 27 Nov 2019 14:31:00 GMT

If you are not showing the tab row, that could be the issue. I have encountered this several times, and reported it, but macros are not supported. Try enabling the tab row in the Settings > Document Properties > General and see if that helps.

Re: Macro doesn't work

qliksus — Fri, 29 Nov 2019 08:09:45 GMT

Why dont you run the macro on Activate sheet trigger in the sheet properties ?

Re: Macro doesn't work

Brett_Bleess — Tue, 10 Dec 2019 14:38:12 GMT

Did either of the posts help you? If so, be sure to use the Accept as Solution button on the one(s) that did help, and if you are still trying to sort things out, leave an update on things. The only other workaround would be to use a Button on each sheet that would call the macro, that should work consistently no matter what, but I know generally folks want to do it automatically.

Regards,
Brett