deactivate save changes

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
 
T

Tim Williams

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

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

Tim
 
Top