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:

Please Login or Register  to view this content.
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!