Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Macro doesn't work

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 



3 Replies

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.
Specialist II
Specialist II

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

Former Employee
Former Employee

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.


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.