ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Updating Links (https://www.excelbanter.com/excel-discussion-misc-queries/199487-updating-links.html)

Varne August 20th 08 01:23 PM

Updating Links

I am trying to use the 'open workbook' event to automatically update links
(without I saying yes) in the opened workbook. However if the linked workbook
is protected I am asked for the password. How can I incorporate the password
in the 'open workbook' event so that it will not request for a password and
update links without asking questions?

Could someone help?


M Varnendra

All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.