Background Information
Project Server administrators frequently want to make a VBA procedure or event available to all projects in the Project Server database. To attempt this, you can add the VBA code to an enterprise project template, but you cannot force every project manager to use the template. Worse yet, if you update the code, you must manually update each project template and every project individually.
Resolution
Add the VBA code to the Enterprise Global file. The system makes all VBA code in the Enterprise Global file available to all enterprise projects and updates the latest version of the VBA code automatically each time a project manager logs into Project Server through Microsoft Project Professional. To add your VBA code to the Enterprise Global file, complete the following steps:
1. Launch Microsoft Project Professional and log into Project Server with administrator permissions
2. Before making changes to the Enterprise Global, backup the file using Tools > Enterprise Options > Backup Enterprise Global
3. Click Tools > Enterprise Options > Open Enterprise Global
4. Click Tools > Macro > Visual Basic Editor
5. Click View > Project Explorer if the Project Explorer sidepane is not displayed in the Visual Basic Editor window
6. Select the Enterprise Global by double-clicking “ThisProject (Checked-out Enterprise Global)” in the Project Explorer sidepane, as shown in the following illustration
Visual Basic Editor: ThisProject selected
7. Enter your VBA code
8. Save the VBA code
9. Close the Visual Basic Editor window
10. Save and close the Enterprise Global
11. Exit and relaunch Microsoft Project Professional
Note: From this point forward, all enterprise projects will have access to this code. Depending on the Security Level set using Tools > Macro > Security, your project managers may see a security warning each time they launch Microsoft Project Professional and log into Project Server.