how do i get a message to pop up when closing excel 2007

  • Thread starter Thread starter bobhogg
  • Start date Start date
B

bobhogg

I wish to prompt a user to do something when they close excel 2007 i want a
message to pop up on closing or saving
 
hi
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel as Boolean)

MsgBox("Boo!!!!")

End Sub
Private Sub Workbook_BeforeClose _
(Cancel As Boolean)

MsgBox ("Boo!")

End Sub

this is workbook code so you can call these events from the workbook module.
or substitute your message and paste into a workbook module.

Regards
FSt1
 
You must log in or register to reply here.

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

Excel Providing user message when RED X clicked & properly closing application. 2
Excel 2007 formula recalculation 1
Personal Macro 1
Is there a comparison list of commands? (Excel 2003 vs 2007) 2
"Save file before closing" 2
file format or file extension is not valid...error message 0
Prompt to Save Message 2
MS Office 2007 configuration 1

Back
Top