Macros are not visible from the other machine

S

sirichan

I have created 'macros' and saved them globally with the
MS project (on NetWork drive).When my colleague opened the
same from her machine, the macros were not getting
displayed. The Macros I have created were been saved
globally. I have checked the security settings on MS
project. The Security level is Medium on both MS project
views.

Does any one know what could be happening? Any hint on
this would be highly appreciated
 
G

Gérard Ducouret

Hello Sirichan,

If you saved your macros "globally", I guess they are saved in the
Global.mpt file on your own hard disk. So your colleague can't access them
on her own PC.
Use the Organizer to copy the VBA modules from one global.mpt to another :
Tools / Organizer... / Modules

Hope this helps,

Gérard Ducouret
 
J

Justine

I am having the same problem and was just about to post it. I was given a macro as the solution to the refresh problem when using a master project. I store this document on a shared drive so that my boss and colleagues can access it and/or update it. However, when they open the file they don't have the macro. Any thoughts/suggestions?
 
R

Rod Gill

Hi,

A global.mpt file can be shared on the network. Tim Pyron in an old Woodys
Project Watch article
(http://www.woodyswatch.com/project/archtemplate.asp?2-04) detailed how
Project looks for the Global file:

1.. System Policy Keys in the Windows Registry
First, it looks in the Registry to see if there is a system policy that
defines which Global file is to be used. If a policy key exists and
correctly points to a Global file, it uses that file. The registry key that
is used for the policy settings is:
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\9.0\MS
Project\GlobalSearch

2.. The Current Folder
What happens next depends on how you have launched Project 2000:
a.. If you have launched Microsoft Project by double-clicking a Project
document (an .mpp file) in Windows Explorer then Project looks for a
Global.mpt file in the folder where the Project document is located. You can
use this feature to activate different Global files for different projects:
place a special Global file in the folder that contains the project
document and launch Project by double-clicking the document.
b.. If you have launched Project with a shortcut that defines a folder in
the Start In field of the shortcut's Properties, and that folder contains a
Global file, then Project 2000 loads that Global file when it opens. This
provides another method for using different Global files with different
projects: use different shortcuts for different versions of the Global
template.
c.. If you run Project 2000 from a network server it looks for the Global
file in the working folder on the your local computer first. If there is
none, it looks for a Global file on the server.
3.. Next, Project 2000 looks in the user's profile folder.
In Windows 98 this is the folder \Windows\Profiles\Username\Application
Data\Microsoft\MS Project. In Windows 2000, it is the Application Data
folder for the user profile.

4.. The user's profile language folder
In Windows 98 for English this is: \Windows\Profiles\Username\Application
Data\Microsoft\MS Project\1033

For other languages you will see a different folder at the end instead of
1033. For instance, if you install the German version of Project 2000 the
end folder will be 1031.

5.. The folder containing the Project 2000 executable (Winproj.exe)
In the default installation the executable's folder is \Program
Files\Microsoft Office\Office

6.. The executable's language folder
In the default installation for English this would be \Program
Files\Microsoft Office\Office\1033
If no Global file is found, then Project will create a new generic Global
file and place it in the executable's language folder.

I think this is what Project still does. So, copy a global to a shared
folder, then use a short cut and start-in address or another method to point
to it. Failing that, put teh Global in teh same folder as the project file.
--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top