Thanks Ron - Will the add in allow me to store 20 passwords for all the
different files?
M
"Ron de Bruin" wrote in message
...
Hi Michelle
Maybe you can use this add-in to get the values when you need them
There is a option to fill in the password
http://www.rondebruin.nl/merge.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Michelle" wrote in message
...
Hello, I have a summary sheet which links to many (20ish) password
protected files. Every time I open it or update the links, I have to
enter many (20ish) passwords.
Is there a way I can avoid or automate this process.
I am happy to use VBA (or any other method), but bear in mind that the
files are big and take 10 seconds or so to open.
I'd really appreciate any feedback.
Many thanks
M