PDA

View Full Version : VBA Module permissions



presence76
03-02-2006, 06:29 AM
I created a VBA macro within a word document on a shared network drive. How come when I go to another PC(signed on as another user), it can see the document but not the Macro I just created?

Thanks in advance.

matthewspatrick
03-02-2006, 07:26 AM
Are you sure your macro is in a document, and not, say, in your local Normal.dot or some other template?

presence76
03-02-2006, 07:51 AM
Yes, that is correct. I copied the module from Normal to project and it became available. Thanks.

matthewspatrick
03-02-2006, 08:02 AM
You're most welcome.