excel resets charts SizeWithWindow and Zoom

C

chet

I have a series of procedures which generate a lot of statistics and
charts and set the charts' property
.SizeWithWindow = False
and the window magnification
.Zoom = 100
Everything works fine and the charts are output as specified in the
vba code. But after I close the workbooks and reopen them, excel has
reset all the chart Views to Sized With Window (checked) and Zoom to
127%. Is there a way to prevent excel from resetting the View and
Zoom properties? Thanks for any help or suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel resets chart values after workbook reopen 0
Issue creating charts in excel sheet 2
Charts that are Off-Screen Disappear after update 4
Excel Zoom Violates Chart Size Integrity 3
Why do charts disappear? 3
Disappearing Graphs 5
Bug with newest Excel Update 7
Blank Charts and Paste Special 5

Top