xcellrodeo
Board Regular
- Joined
- Oct 27, 2008
- Messages
- 206
Good day, I was wondering if I could get some advice on the following.
I have an Excel workbook that has formulaic links to ca. 20 different workbooks (each p/w protected).
Every time I open the workbook to update all links I get 20 windows popping up asking for passwords.
So I have tried to address this by creating a Workbook.Open code. However it still opens 20 workbooks which causes it to crash.
However, the problem with this is that it appears to physically open each workbook (and if its read-only because someone else appears to have the file open at same time) it throws up a window asking for p/w to view read only.
Desired solution:
Is it possible to update all links without having to open each individual p/w protected linked workbook?
If so, what would be the code for this?
Thanks for your help.
I have an Excel workbook that has formulaic links to ca. 20 different workbooks (each p/w protected).
Every time I open the workbook to update all links I get 20 windows popping up asking for passwords.
So I have tried to address this by creating a Workbook.Open code. However it still opens 20 workbooks which causes it to crash.
However, the problem with this is that it appears to physically open each workbook (and if its read-only because someone else appears to have the file open at same time) it throws up a window asking for p/w to view read only.
Desired solution:
Is it possible to update all links without having to open each individual p/w protected linked workbook?
If so, what would be the code for this?
Thanks for your help.
Last edited:
