Dkline
Mon Feb 21 14:46:29 CST 2005
I did follow Alex's suggestion of looking in the templates folder. I made
sure that I preserved the original DOT file before affecting it in any way
shape or form.
I ended up having to export the two modules from my Normal.Dot and then
import them into the user's Normal.Dot. This way I did not affect her
settings and she is now able to run the macro. She did not have any modules
in her Normal.Dot.
She is a happy camper.
"Charles Kenyon" <msnewsgroup@remove.no.spam.addbalance.com> wrote in
message news:uRjdbKFGFHA.3120@TK2MSFTNGP12.phx.gbl...
> The normal.dot file should _not_ reside in My Documents! It should be in a
> separate folder. Documents and templates should be kept separate. For more
> on the different kinds of templates, tabs on the file new dialog, and
> locations of templates folders see
>
http://addbalance.com/usersguide/templates.htm. You should _not_ just be
> copying your normal.dot over the top of your user's unless there is a
> problem with their normal.dot. Even then, it should be renamed and
> recreated.
>
> See
http://addbalance.com/word/movetotemplate.htm for step-by-step
> instructions on moving / sharing / copying / backing-up customizations
> including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
> etc.
> --
>
> Charles Kenyon
>
> Word New User FAQ & Web Directory:
http://addbalance.com/word
>
> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide)
http://addbalance.com/usersguide
>
> See also the MVP FAQ:
http://www.mvps.org/word which is awesome!
> --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
>
> "Dkline" <Dkline001@comcast.net> wrote in message
> news:OJCTfADGFHA.3472@TK2MSFTNGP09.phx.gbl...
>>I have written a macro in a document on a shared network drive. When I
>>open any document, I can see and run the macro as the macros are in the
>>Normal.dot.
>>
>> The other two people do NOT see and cannot run the macro.
>>
>> The actual VBA is in the Normal.Dot. The macro (atcually series of
>> macros) rebuilds the "master" document out of a collection of individual
>> documents. Basically it insert a series of files into the "master"
>> document and then creates a hyperlinked TOC. Does everything we want it
>> to do in terms of rebuidling the document.
>>
>> Even wehn I take this Normal.Dot and drop it into their "My Documents"
>> where their original Normal.Dot was kept, they still can't see these
>> macros.
>>
>> I had them both set their Macro Security to low. So that is not an issue.
>>
>> I have exported the two modules to .BAS files. Do I need to import them
>> to their copy of Normal.Dot even though I copied my Normal.Dot into their
>> "My Documents"?
>>
>
>