Macro to Prompt User to Close After Saving
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "I would like to prompt users of a " _
& "public Excel file to close the file or " _
& "application after they save it so that " _
& "when they hit Save, a message box " _
& "prompts them to that effect."
End Sub
"Rutabaga" wrote:
Hello All,
I have Office 2003.
I would like to prompt users of a public Excel file to close the file (or
application) after they save it so that when they hit Save, a message box
prompts them to that effect.
Thanks in Advance
|