Macro in document availablke only to one user

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dkline - 21 Feb 2005 16:12 GMT

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

Reply to this Message

Alex Ivanov - 21 Feb 2005 17:19 GMT

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.

Signature

Please reply to NG only. This email is not monitored.
Alex.

>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
[quoted text clipped - 17 lines]
> their copy of Normal.Dot even though I copied my Normal.Dot into their "My
> Documents"?

Reply to this Message

Dkline - 21 Feb 2005 20:47 GMT

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.

> My guess is that you are copying your normal.dot into a wrong folder.
> Check (and modify if necesserily) settings under Tools/Options/File
[quoted text clipped - 22 lines]
>> to their copy of Normal.Dot even though I copied my Normal.Dot into their
>> "My Documents"?

Reply to this Message

Charles Kenyon - 21 Feb 2005 20:18 GMT

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.

Signature

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.

Reply to this Message

Dkline - 21 Feb 2005 20:46 GMT

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.

> 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
[quoted text clipped - 30 lines]
>> to their copy of Normal.Dot even though I copied my Normal.Dot into their
>> "My Documents"?

Reply to this Message