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