Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup when saving or closing
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, -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup when saving or closing
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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving and closing | Setting up and Configuration of Excel | |||
Saving and Closing | Excel Worksheet Functions | |||
Saving and Closing | Excel Discussion (Misc queries) | |||
closing & saving | Excel Worksheet Functions | |||
VBA - closing without saving changes | Excel Programming |