Auto run macro

Z

zip

Hi,

I am having trouble figuring out how to create an auto run macro, triggered
when
you open a project file. Is there a simple way to code this in vb?

Thank you,

zip
 
G

Gérard Ducouret

Hello Zip,

Press Alt + F11 to open the VB Editor
Double Click the "ThisProject" leaf on the left to create an event module.
In the first drop down list on the right, instead of (General) select
Project
In the second drop down list, select Open
the system creates the procedure :
Private Sub Project_Open(ByVal pj As Project)

Hope this helps

Gérard Ducouret
 

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