Creating Messages

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I am interested in creating a message that will automatically pop up when I
go to save a document. Any suggestions?
 
Cathy,

Alt +F11 to open VB editor double click 'ThisWorkbook' and paste the code
below in on the right. Edit message & Title to suit.


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
resp = MsgBox("Here's a message fro me", vbInformation, "My Message")
End Sub

Mike
 
Thank you for your response. I followed your instructions below but it
doesn't seem to be working. Once I copy and paste what is my next step?
 
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

Windows 7 64bit Auto shutdown problem 1
Creating Word docs from Excel with VBA 3
userform program keeps crashing 4
Create Pop-Up quiz Window with yes no questions 0
Run-Time Error '424': Object required when Saving Document 6
Excel Providing user message when RED X clicked & properly closing application. 2
Blue screen error message 1
make message box appear when cell is clicked? 1

Back
Top