Hi there,
While migrating a macro from Office 2003 to Office 2010 I encounter following problem.
The macro makes 4 new graph sheets and set the Zoom of each of them to 100%.
In Office 2003 that worked fine, each graph was zoomed to 100% and was always showed that way.
In Office 2010 I found out that, when selecting a grah sheet, once the macro was finished, the graph shows 100% zoom only for a very short period of time (less than 1 second).
The graph was then resized to full window size, 122% in my case.
In an attempt to find out the reason I've made the file, you can find here http://www.helpmij.nl/forum/showthread.php/638507-Zoom-grafiek-automatisch-aangepast
Go to the second post and download the "GraphProbleem.xlsm" file.
With the "Graph Ok" button 2 graphs are made that keep the 100% zoom setting.
With the "Graph Niet Ok" button 2 graphs are made that lose the 100% zoom setting.
Only difference..............................
Anyone ever mentioned this problem???
I then tried this in my original macro and indeed it works, but setting Screenupdating to False while executing the macro, even just before each
line cause the screen to flicker 
Anyone with a better solution??
Thanks!
While migrating a macro from Office 2003 to Office 2010 I encounter following problem.
The macro makes 4 new graph sheets and set the Zoom of each of them to 100%.
In Office 2003 that worked fine, each graph was zoomed to 100% and was always showed that way.
In Office 2010 I found out that, when selecting a grah sheet, once the macro was finished, the graph shows 100% zoom only for a very short period of time (less than 1 second).
The graph was then resized to full window size, 122% in my case.
In an attempt to find out the reason I've made the file, you can find here http://www.helpmij.nl/forum/showthread.php/638507-Zoom-grafiek-automatisch-aangepast
Go to the second post and download the "GraphProbleem.xlsm" file.
With the "Graph Ok" button 2 graphs are made that keep the 100% zoom setting.
With the "Graph Niet Ok" button 2 graphs are made that lose the 100% zoom setting.
Only difference..............................
Code:
Application.ScreenUpdating=TrueI then tried this in my original macro and indeed it works, but setting Screenupdating to False while executing the macro, even just before each
Code:
ActiveWindow.Zoom = 100Anyone with a better solution??
Thanks!
