Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bypass "Links to Projects" window in MS Project in VBA macro

Status
Not open for further replies.

technar

Technical User
Sep 6, 2011
9
AU
Hi,

I have a list of projects in Excel and I have written a macro to run through the projects, open it on by on in MS Projects, manipulate the view and print to PDF file.

My problem is that I cannot bypass "Links to Projects" window that pops up on some projects as it required user interaction (i.e. click button "Close")

Any ideas how to stop this window from appearing or close it if it appears?

Thank you.
 
* corrections: macro opens projects one by one
 
Try Application.DisplayAlerts = False

If not put it at the start of your code and then make it true in your error handler and when the code ends.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top