Turn Off save prompt, reminder when closing modified WORD...
DaveO wrote:
You could quickly write a routine that set the app warnings to be false on
the BeforeClose event if it was too much of an issue ...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
End Sub
HTH.
But if the workbook does not currently contain macros then you'd have
warnings about macros to click through before it opens or remember to
hold the shift key down to disable the macros.
Looks to me like a no win situation. Excel's just doing what comes
naturally.
Regards
Steve
|