PC Review


Reply
Thread Tools Rate Thread

Creating Messages

 
 
Cathy
Guest
Posts: n/a
 
      3rd Apr 2009
I am interested in creating a message that will automatically pop up when I
go to save a document. Any suggestions?


 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      3rd Apr 2009
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

"Cathy" wrote:

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

 
Reply With Quote
 
Cathy
Guest
Posts: n/a
 
      6th Apr 2009
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?
--
Cathy


"Mike H" wrote:

> 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
>
> "Cathy" wrote:
>
> > I am interested in creating a message that will automatically pop up when I
> > go to save a document. Any suggestions?
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating EDI messages programmatically in /net/c# Shikari Shambu Microsoft C# .NET 0 13th Jul 2009 02:39 AM
Re: Creating Messages Per Jessen Microsoft Excel Programming 0 3rd Apr 2009 07:05 PM
creating and sending UDP messages Alessandro Microsoft C# .NET 2 14th Mar 2005 06:03 PM
Creating or Replying to messages Scott Microsoft Outlook 1 13th Apr 2004 11:18 PM
Creating messages Robert Cleveland Microsoft Outlook 3 9th Jul 2003 11:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:19 AM.