Hi,

Am new to this forum and looking for an easy way to refresh links to other workbooks, all to source workbooks which are password protected.

I have a master workbook which pulls in various values and I simply want to enable the user of the master workbook to refresh the links without having to input the various passwords. Can I do this without having to open the source workbooks?

Or if I have to open the source workbooks as part of the Macro, is there an easy command to then close them down?

Any advice would be greatly appreciated.