Pass a linked sheet's password in VBA

[Gingaskunk]

Hey guys,

I've used the forums for ages but this is my first post (most other things I need I've found in previous posts). Can't find an answer to this one though.

So here's where we are.

Excel Workbook A has a macro that opens Workbook B and does a simple Application.Calculate. However Workbook B has external links in it to Workbook C, which is password protected.

I don't actually need to update the link to Book C when running book A's macro, but right now running it causes "can't update links" pop up that I'm trying to prevent.

I see three ways around this.

a) Turn off notifications during the macro. This would work, but we'd like to see any pop-ups in case there's an issue with Book B we might not otherwise catch.
b) Exclude that update to book C in the application.calculate
c) Pass in the password for workbook C when I run the Book A macro.

What am I missing? I have no idea how to achieve either b or c!

Thank you all.

 

[ask2tsp]

What you can try is specify "UpdateLinks:=0" in the workbooks.open statement

 

[Gingaskunk]

What you can try is specify "UpdateLinks:=0" in the workbooks.open statement

Thank for your input I appreciate it. The issue is that there are about 6 other books linked to this file we DO want to update, "UpdateLinks:=0" will prevent any of them from updating.