Run on Open

[jsl]

I want to do a "run on open" so I set up the code in my file under
"Microsoft Project Objects" as follows (courtesy Jack's helpful
website)..

Private Sub Project_Open(ByVal pj As Project)

AddMyMenuBar

End Sub

The code for AddMyMenuBar is in the Global.MPT.

However whenever I open the Project file in which I've set all this up,
I get an error "Sub or function not defined."

My guess is that Project/VB is only looking locally for "AddMyMenuBar"
and not looking in the Global.mpt. From my miscellaneous reading, I
can't figure out what to change to set the scope appropriately.

I would prefer if at all possible to keep the code for "AddMyMenuBar"
in the global so that I don't have to copy it into every Project
schedule that needs to run the code on open.

 

[JackD]

Try referring to the macro like this:
----------snip------
Private Sub Project_Open(ByVal pj As Project)

Application.Macro "global.MPT!module1.AddMyMenuBar"

End Sub
---------snip----------
You will need to replace the "module1" with the name of the module that
AddMyMenuBar is located in.

 

[jsl]

thx much. I knew it was something simple ...

 

[JackD]

No problem. I just put up an article about this:
http://zo-d.com/blog/archives/programming/working-with-modules-and-macros.html
It covers a couple of the other methods for dealing with it.