Macro in document availablke only to one user

[Dkline]

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"?

 

[Alex Ivanov]

My guess is that you are copying your normal.dot into a wrong folder. Check
(and modify if necesserily) settings under Tools/Options/File Location/User
Templates to see where is an active normal.dot resides. There are often
several normals on a computer, but only one is active.

 

[Charles Kenyon]

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.

 

[Dkline]

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.

 

[Dkline]

I ended up having to export the two modules and them import them into the
user's Normal..Dot. They seemed to get lost in the shuffle with a straight
copy.