Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why dont you run the macro on Activate sheet trigger in the sheet properties ?
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