Popup when saving or closing

R

rglasunow

I would like to have a popup window appear when a user either closes o
saves a document in Excel. Is this possible?

thank you,
 
P

Pyball

Yes it is. You would put your code in the Before Workbook Close even
and/or Before Workbook Save event.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Have a nice day!", vbOkOnly
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)
MsgBox "Your workbook has been saved.", vbOkOnly
End Sub

You can put what ever you want in the quotes.

Hope this helps you out
 
Top