Saving Workbooks w/ Charts
 

Apparently an Excel Workbook w/ at least one Chart
in it will normally ask if the user wants to Save it,
even if no changes of any kind have been done...
This is "Scenario A".

That can be prevented by adding the below in the
Excel Object "ThisWorkbook"....

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub

However, this stops a request to save a change WHEN
something has been changed = This is "Scenario B".

How do I prevent "Scenario B", but retain "Scenario A"???

TIA - Bob

Saving Workbooks w/ Charts
 

Having a chart is not enough to make the workbook ask to save changes on
closing. Make sure there is no volatile data, such as RAND() or NOW().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bob Barnes" wrote in message
...
Apparently an Excel Workbook w/ at least one Chart
in it will normally ask if the user wants to Save it,
even if no changes of any kind have been done...
This is "Scenario A".

That can be prevented by adding the below in the
Excel Object "ThisWorkbook"....

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub

However, this stops a request to save a change WHEN
something has been changed = This is "Scenario B".

How do I prevent "Scenario B", but retain "Scenario A"???

TIA - Bob