Display Alerts for Save

[Andrea001]

I've set DisplayAlerts to False before I close the current workbook because I don't want to be prompted to save. However I'm worried about the macro closing before it has a chance to reset the DisplayAlerts to True. Is this an issue I need to address or does Excel automatically set the DisplayAlerts to true when opening a new file?
Thanks,
Andrea

 

[rmikesmith]

Andrea,

Here is what I have discovered by testing the DisplayAlerts property, at least in Excel 97:

1) Although the Help entry says DisplayAlerts will not automatically be re-set to True after a macro ends (as was the case for earlier versions), it was.

2) Setting DisplayAlerts = False did not prevent Excel from prompting to save changes.

Based on this, I would answer that there is no issue with the macro terminating before DisplayAlerts can be re-set. To prevent Excel from prompting to save changes, use

ThisWorkbook.Saved = True

inside the

Workbook_BeforeClose

event procedure.

Hope this helps.
M. Smith