Macro doesn't work

[Ayoub]

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 

[Miguel_Angel_Baeyens]

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.

[qliksus]

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

[Brett_Bleess]

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