deactivate save changes

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

Excel 2003

I execute code in Before Close workbook in This Workbook

My problem is that excel re-asks if the user wishes to save changes after
doing the code.

Is there a way to deactivate the save changes dialog?

Many thanks
 
Add:
ThisWorkbook.Saved=True
at the end of your code.

(assuming you don't want them to save it...)

Tim
 
Back
Top