Referencing password protected worksheets
I have some Excel files that are password protected. Now
I need to do a summary that refers to all of the
workbooks. I have run into a big problem!
The summary workbook asks for each password, one by one.
Is there a way I can refer to a worksheet without having
to put in the password each time?
Thanks in advance.
|