Hi,
I've noticed a very strange behaviour of the zoom function in Excel 2013:
When I change the zoom level using the zoom function from the menu it works perfectly fine - my sheet gets immediately zoomed in or out together with all the graphics (pictures, shapes etc.)
When I try to do the same via VBA, things get different...
I have the following code:
When I run this macro from the list of available macros (Alt+F8) zooming works almost as fast as doing it manually as before...
However, when I assign this macro to a simple button (or a picture) and click on it, the macro runs quite slowly - first all the pictures and shapes get zoomed in or out (depending on the previous zoom level) and only after a while (a second or so) the sheet itself is zoomed which is quite annoying and strange...
When I assign the macro to an ActiveX control - no problems.
So the strange behaviour occurs only if the Zoom() macro is assigned to a picture or a simple form control...
Does anyone have any idea of what could be the reason of this?
Thanks in advance for your help!
Bookmarks