Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Message on opening a document

Status
Not open for further replies.

ngardner

Technical User
Apr 1, 2002
35
AU
I would like to create a message that pops up when people open certain documents in our office. This would be similar to a field that prompts for information to be filled in, however I just want a box that has a standard reminder.
I assume I would achieve this with some kind of macro. Does anyone have any ideas??
Thanks
 
Hi ngardner,

Open the document in question.
Hit Alt-F11 to bring up the VB editor.
In the left hand window find your document (ThisDocument).
Double Click on it to bring up the code for this doc.
In the two drop down boxes choose "Document" and then "Open"
and use this code..

Private Sub Document_Open()
MsgBox "Your Text Here...", vbOKOnly, "Your title"

End Sub

If anything needs clarification, don't hesitate to reply again.

Regards,

Peter
Remember- It's nice to be important,
but it's important to be nice :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top