I have a workbook that updates from several other workbooks which are all password protected to open. The passwords for the workbooks are all the same. I am looking for a way to have the passwords inputed automatically for me when I update the links when opening. Any suggestions?