View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck M Chuck M is offline
external usenet poster
 
Posts: 54
Default 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.