If I understand correctly, put this in the ThisWorkbook module (see VBE Project window):
and this in a normal module![]()
Private Sub Workbook_BeforeClose(Cancel As Boolean) x End Sub Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) x End Sub
But what is the point of this?![]()
Sub x() MsgBox "Text here", vbOKOnly End Sub
Bookmarks