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

"Roger on Excel" <(E-Mail Removed)> wrote in message
news:A0F1139B-C9B2-438E-86B8-(E-Mail Removed)...
> 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