Help using VBA in MS Project Pro 2007

[migv1]

I have written "gatekeeper" code that checks a user's credentials and applies the appropriate filter (and disables command bars) so that users are restricted to viewing and editing only tasks owned by their departments. The code works fine when Project Pro is already running, but I can't seem to make it work so that it checks for credentials before the application opens.

There doesn't seem to be a "before open" option - what is the proper way to run code at Project Pro startup (whether opened standalone or from Project Server 2007)? I'm assuming the code should be stored in Enterprise Global so that it will be applied to all files created or opened online.

Thanks in advance for any help.

 

[SkipVought]

http://msdn2.microsoft.com/en-us/library/bb213836.aspx

AFAIK, there is no Before_Open event. You must check in the Open event handler.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]