Making event driven code available across the enterprise

[Neil A]

Hi,

I am trying to find a way to make some VBA code run when MS Project Pro
users open any enterprise project. That is, I want it to be tied to the
project Open event. However, I don't want each user to have to go and
connect the code to the Open event for each of his/her projects.

Is there a way this can be done using the Enterprise Global Template? I've
tried adding code to events in my Global.MPT, but it doesn't get called.

Thanks in advance.

 

[Gérard Ducouret]

Hello Neil,
Open the Enterprise Global, go to the VB editor (ALT F11) and select the
ThisProject object.
In its VBA module, type a procedure which will by triggered by the Open
event :

Private Sub Project_Open(ByVal pj As Project)
MsgBox "You are openning : " & ActiveProject.Name
End Sub

Hope this helps,

Gérard Ducouret

 

[Neil A]

Thanks Gerard,

That works fine.

 

[Gérard Ducouret]

You are welcome, Neil

Gérard Ducouret