I have 2 workbooks in my company network (a password needs to be entere
to open them). Each workbook has several sheets, the first sheet o
each workbook is a summary sheet.

I have a third workbook in the network which is just the summary sheet
of the forementioned workbooks.

This is where my question is raised...
When I open the 3rd workbook I'm prompted with a message about wantin
to update. If I select "Update" I am presented with an passwor
inputbox. (I'm sure ALL of you have seen this)

Now... if there any way to take care of the password inputbox so th
password is entered automatically for the user... It is the sam
password for the 1st 2 workbooks.

I am a little cautious about giving them the password, they might ge
wise and find the first 2 workbooks over the network and well... let'
just say they're not so trust worthy. :)

Can any1 help?

- Larry -
VBA Amateu

--
Message posted from http://www.ExcelForum.com