I am trying to link two workbooks. The source book has all the information
entered and stored. The other workbook will only be used by a limited
number of people to access designated information from the source workbook.
My problem is that the source workbook is password protected. When I open
the second workbook, I want it to update the information, but it asks for a
password to retrieve the information.

How would I set up a VBA code to automatically update the second workbook
with the source workbook and automatically enter the password so the user
doesn't need to know the password.

Does this make sense?

Help!!

Mark