Passwords

  • Thread starter Thread starter Frank B
  • Start date Start date
F

Frank B

I have a summary roll up file that is linked to about 15
other workbooks that have password protection on them.
Because of the passwords when I pull up the linked roll up
file it asked for ALL workbook passwords (15) in all. Is
there a VBA statement that I can add to my statement that
calls the rollup file to not recognize the passwords???

Thanks
Frank
 
-----Original Message-----
Take a look at Worbooks.Open in Help, specifically the UpdateLinks
argument.


.
Don't mean to sound dumb, however do I find this in the
Click to expand...
Excel help on my computer or is it on the web.

Thanks
Frank
 
-----Original Message-----
roll
Excel help on my computer or is it on the web.

Thanks
Frank
.
Thanks JE, I found the article you reference, however I
Click to expand...
don't see anything in there on how to ignore the passwords

Thanks
Frank
 
Type Alt-F11 to get into the VBE. Then choose Help/Search Microsoft
Visual Basic Help.
 
Back
Top