I have a set of 7 workbooks and one master workbook that I have created links between. I have them all stored on a cloud service, as the users of each spreadsheet are all over the country. Each spreadsheet needs to have a password to access the spreadsheet.

Is there a way to maintain the integrity of the links without having to enter the password for each spreadsheet, each time you access it?

I have seen other posts about VBA/macro coding, but I am not familiar with this, and need some additional guidance.

Thank you for any help you could offer!