Links to a workbook that is password protected
 

Hi,
I posted this questions earlier in the day but this may give a picture of
what I'm trying to do.....

I have a workbook ('A') that gets updated via links from another workbook
('B'). When the users open workbook A, I don't want them to see the Update
Links dialog (I've already taken care of this through
ToolsOptionsEdit'ask to update automatic links') or to have to enter the
password to workbook B. Is there a way through VBA to send the password? I
don't want users of A to have the password to B.
--
Thanks.
Chuck M.