View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ScottMSP ScottMSP is offline
external usenet poster
 
Posts: 34
Default Open Multiple Password Protected Workbooks with Macro

Hello -

I have scoured the discussions boards, but have not found an answer to my
question and thus this post.

I have 10 workbooks that are each individually password protected with
unique passwords that I would like to be able to open all 10 at once using a
Macro.

I want to avoid having to individually click on and open each workbook and
key the unique password.

I plan for this to be part of a broader Macro doing other steps, but I have
not been able to find the solution to this part of the problem.

Thanks in advance.