I have a workbook that I do not want the user prompted to save whenever they
close it. Is there a way I can disable that popup? Maybe override the
Workbook_OnClose event?
I have a workbook that I do not want the user prompted to save whenever they
close it. Is there a way I can disable that popup? Maybe override the
Workbook_OnClose event?
Found it.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub
Works.
"Scott buckwalter" wrote:
> I have a workbook that I do not want the user prompted to save whenever they
> close it. Is there a way I can disable that popup? Maybe override the
> Workbook_OnClose event?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks