I have a workbook that has links from many other workbooks. They all feed from workbooks that are password protected to open. I need a macro or some way of not having to put all the passwords in everytime I open and update my main workbook. All of the passwords are the same. Any suggestions? Thanks.