Skip the "save your changes?" message when closing file

[Bagharmin]

I searched for this, but apparently not correctly as I couldn't find anything that addressed it.

When a user closes the workbook in question, my code clears the cell where their username was. So, even if they just saved the workbook, it will clear their name then Excel will ask if they want to save their changes. How do I skip the "Do you want to save your changes" message when Excel is closed? Or, how do I automatically select "Yes"?

Thanks.

 

[xenou]

Your code could be amended (assuming this is in the before save event in the this workbook module):

Dim MySaved As Boolean
MySaved = Me.Saved
'Clear name
Me.Saved = MySaved

 

[Smitty]

To suppress the message, wrap it in Application.DisplayAlerts = False and set it back to True at the end.

If you want to save the workbook without their interaction you can use Activeworkbook.Close True. Change it to false if you don't want to save it.

HTH,

 

[Bagharmin]

Thank you both very much. That's what I need.