Enable connections

[tlindeman]

Good morning,
I have a workbook called "ENterprise KPIS" that has formulas that refer to another workbookn called "BALANCE SHEET" that is password protected. I have office 2007 so everytime I open up Enterprise KPIs, I have to enable automatic update of links and then enter the password, is there code that would take care of that for me? So when I open Enterprise KPIS, it autoupdates links and enters the password?

Thank You
Tony

 

[TiaXL]

Good morning,
I have a workbook called "ENterprise KPIS" that has formulas that refer to another workbookn called "BALANCE SHEET" that is password protected. I have office 2007 so everytime I open up Enterprise KPIs, I have to enable automatic update of links and then enter the password, is there code that would take care of that for me? So when I open Enterprise KPIS, it autoupdates links and enters the password?

Thank You
Tony

as far as I know the only way to do this is to open your file from another workbooks and use the

application.displayalerts = false
workbooks.open("Enterprise KPI's"),password:=blabla

 

[tlindeman]

That will work, thank you