Hi,

I'm working with Excel 2013 64-bit (on Windows 7) and I'm experiencing an issue with the VBA macros running slow and strange on a worksheet with a lot of graphical objects (pictures, buttons, shapes etc.)

Two simple examples:

1. I zoom out MySheet manually to 50% and I want to zoom back to 100%... When I do it manually (via zoom option) it goes quickly and smoothly almost instantaneously. When I do it through a simple one-line macro (ActiveWindow.Zoom = 100) it's going much slower and first all the objects are enlarged back to 100 % while the worksheet itself with all the cell contents get enlarged a bit later, which obviously looks very bad...

2. I activate manually another sheet and want to go back to MySheet...when I do it manually (choosing the MySheet tab) it shows MySheet quickly and smoothly in almost no time. When I do it through a simple one-line macro ( Sheets("MySheet").Activate ) it's going much slower and I see first all the objects from MySheet (with the previous sheet in the background) and it takes a while until the screen is refreshed so that I see MySheet properly...

Any idea what is taking Excel 2013 so long to do these simple tasks via VBA?? (not the case in Excel 2007 or 2010)

Also, I noticed that when I open the list of available macros and run my macro from the list it's going much faster then running it from a button on the sheet (although still slower then doing the task manually)

Btw, turning off Screen Updating does not change anything.


Your help will be appreciated!