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
 

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

Top