Macro to Prompt User to Close After Saving

G

Guest

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
 
G

Guest

Copy this into the This workbook Module

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help on VBA excel macro and API to close an external application 0
loss of redo function after installing auto-save 1
after installing auto-save, lost redo function but kept undo 1
Error 0xC00D3E8E: The property is read only. One way to fix. 1
Excel - No Longer Prompted to Save When I Close File 1
Save As 97-2003 workbook 1
Macro to save and close, then copy file 2
Excel Save Changes Prompt 1

Top