Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbooks Saving | Excel Discussion (Misc queries) | |||
SAVING DATA TO CLOSED WORKBOOKS | Excel Worksheet Functions | |||
Saving changes in shared workbooks | Excel Discussion (Misc queries) | |||
Messages after saving in sharerd workbooks | Excel Discussion (Misc queries) | |||
Saving Charts to .htm | Excel Worksheet Functions |