Creating or Recording Macros on the Enterprise Global Template

Avatar

Creating a Macro in VBA

1. Open Microsoft Project Professional 2007 and connect

2. When prompted, log in to connect to Project Server.

3. Click Tools > Enterprise Options > Open Enterprise Global. This opens the Enterprise Global template.

4. The new project will appear blank. You know you’re working with the Enterprise Global Template because of the file name at the top.

5. Next open the Visual Basic Editor. Click Tools > Macro > Visual Basic Editor.

6. In the Project Explorer window you will most likely see the following projects: Global.MPT, Checked-out Enterprise Global, Global (+ non-cached Enterprise) and Project1. 

7. Make sure that you are working in the Checked-out Enterprise Global.

8. Right click on VBAProject (Checked-out Enterprise Global) >Insert, then Left click on Module.

9. This expands the VBAProject (Checked-out Enterprise Global) to reveal its Modules folder and highlights the new Module for you. In this example the new module is Module4.

10. When finished creating the macro click Save

11. Close the Visual Basic window.

12. You will return to the Checked-out Enterprise Global file in Microsoft Project Professional. Click Save.

13. Close the Checked-out Enterprise Global template.

14. When prompted Check-in the Enterprise Global template.

Posted By: Rick Nobleman

Comments
  • Avatar
    Piyusha

    Good One Rick!!
    It helped.Thanks for the post!!
    Piyusha

Leave a Comment

Advisicon is a Project, Program & Portfolio Management Company. We transform your organization's project management with a mix of methodology and technology that delivers results. Our team specializes in technology implementations, application and workflow development, training and consulting.
5411 NE 107th Ave, Suite 200
Vancouver
WA
98662
United States