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

Similar Threads

Deactivate Events not Firing 12
WorkBook Deactivate Event 2
"Do you want to save changes?" question 5
Excel Macro to un-mute Audio/speakers. 15
Which textbox am I in? 1
VBA editor doesn't prompt to save changes, doesn't save 3
Strange behaviour 4
Track if any changes made after file opened 1

Top