Sharing Macros

[RobV]

I'm trying to share a macro with another PM and having a problem. He opens
the mpp file with the macro in it. He opens the schedule where he wants to
use the macro. He goes into Organizer and moves the macro into his schedule.
But, when he goes to Tools, Macro, Macros, he does not see the macro (even
though he can see it via Organizer). What are we doing wrong?

 

[John]

I'm trying to share a macro with another PM and having a problem. He opens
the mpp file with the macro in it. He opens the schedule where he wants to
use the macro. He goes into Organizer and moves the macro into his schedule.
But, when he goes to Tools, Macro, Macros, he does not see the macro (even
though he can see it via Organizer). What are we doing wrong?

RobV,
You (and he) are confusing the module and the macro. A module is the
container for one or more macros. What you see in the Organizer is the
module name. What you see under Tools/Macro/Macros is the list of macro
names. If the module and macro both have the same name then you
shouldn't have a problem, but it sounds like you stayed with the default
module name of Module1, Module2, etc. that is automatically generated by
the VB Editor.

To find out the module name, open the VB Editor and display the macro
code. In the VB Editor caption header you will see the location of the
module and its name . You can rename the module via the Organizer. I
recommend you transfer often used modules to your Global. That way you
can run the macro(s) within that module on any project file.

Hope this helps.
John
Project MVP

 

[RobV]

Thanks, John. I didn't appreciate the difference between macro and module.
We'll give your suggestion a try.

 

[RobV]

John, another question for you: we have "locked for viewing" the mpp file
that has the macro in it. Can the PM who receives the mpp see the module
through Organizer? If not, is there any way for them to move the macro into
their schedule?

 

[John]

John, another question for you: we have "locked for viewing" the mpp file
that has the macro in it. Can the PM who receives the mpp see the module
through Organizer? If not, is there any way for them to move the macro into
their schedule?

RobV,
No, if the project is locked for viewing, he will not be able to copy
the module to his Global or another file. The only way for him to move
the module is to unlock it. However, if you are concerned about sharing
your code, you could install the module for him since you have the
password to unlock and re-lock it.

John
Project MVP