A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Macros



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2004, 03:36 PM
Kijake
external usenet poster
 
Posts: n/a
Default Macros

I would like to add a macro to a MS Word file so that when the file is opened, it will bring up a page with information and instructions that other secretaries in my department can read, and use to inform those scheduling appointments, so that there is no miscommunication. Is it possible to do this? If so, how do I do it?
  #2  
Old May 20th, 2004, 04:21 PM
Graham Mayor
external usenet poster
 
Posts: n/a
Default Macros

A simple message box may do the trick with a macro saved in the document
template.
That template would have to be available to those opening the document. If
you put macros in the document the macro security will conspire against you
achieving your aim.

Sub AutoOpen()
MsgBox "Put your text here"
End Sub

--

Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word




Kijake wrote:
I would like to add a macro to a MS Word file so that when the file
is opened, it will bring up a page with information and instructions
that other secretaries in my department can read, and use to inform
those scheduling appointments, so that there is no miscommunication.
Is it possible to do this? If so, how do I do it?



  #3  
Old May 20th, 2004, 05:46 PM
Kijake
external usenet poster
 
Posts: n/a
Default Macros

Thank You Graham!! That does exactly what I want. Thank you, and thank you!


  #4  
Old May 20th, 2004, 06:11 PM
Kijake
external usenet poster
 
Posts: n/a
Default Macros

Hmmm. I tried the code, and it opens a message box for users to type in text at the time the file opens. I need to have the information already in place in a box that opens up for users to read before they schedule appointments for teacher candidates. This box will have all of the instructions and information they need to schedule appointments, answer questions, etc.

Which code would I use for the above mentioned box?? I am a huge novice!

TIA!
  #5  
Old May 21st, 2004, 08:34 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default Macros

The message box is simply that - a message box. In this case the message is
"Put your text here" Change that for the message you want to display.

If you want something more complicated, then you could create an on-line
form and a series of macros associated with each field that requires user
input. As the user tabs into the field, the macro runs and pops up the
information associated with that field. In this case, each macro would have
to have a different name.

If you want something even more sophisticated than that you need to
investigate userforms, which gather information and act according to the
information gathered. See
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

--

Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word




Kijake wrote:
Hmmm. I tried the code, and it opens a message box for users to type
in text at the time the file opens. I need to have the information
already in place in a box that opens up for users to read before they
schedule appointments for teacher candidates. This box will have all
of the instructions and information they need to schedule
appointments, answer questions, etc.

Which code would I use for the above mentioned box?? I am a huge
novice!

TIA!



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.