-----Original Message-----
With the document active, from the Tools menu, select Macro and then Macros
and in the Macro name: control of the Macros dialog, type AutoOpen, then in
the Macros in: control, select the document and then click on the Create
button. This will open the Visual Basic Editor and you will see:
Sub AutoOpen()
'
' AutoOpen Macro
' Macro created [Date] by [You]
'
End Sub
Insert the line of code that I gave you before the End Sub.
If you only wanted to display a control for the user to enter their name,
use the following code:
Application.UserName = InputBox("Please enter your name", "Name")
There is nothing that you can do to prevent the user from disabling macros.
--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
Thanks Doug-
That's what I need...now..couple more things:
I created the macro -but I do not know how to do
the "AutoOpen" piece - I could not find that as an
option/setting. Is that done with another line of code?
If so could you share that.. thanks
Also, are there optional UserInfo dialog boxes? - is
there a short version without the address section? If
not this will work!!!!!!
Can we set something so they cannot disable this macro,
so they can't cancel it.
The file will be on the server... and a shortcut will be
placed on all workstations startup menus. We are trying
to use this as a communication tool in a law enforcement
office. Daily/shift updates will be posted on this -
each officer/dispatcher will see it as soon as they
login - and should post to it at the end of the day. We
are planning to turn on tracking so user submittals are
identified... The users share PCs, since they are staffed
24/7 - so we are looking for a way to identify user
rather then PC name.
I think this will work - any other ideas that might be
better?
THANK YOU SO MUCH FOR YOUR HELP AND TIME!!!
Cindy
the
macro.
.