Thread: Unprotect use 2 passwords possible??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Unprotect use 2 passwords possible??
Figured it out....on error go to next

Tks!
wrote:
I have a unique scenario where I need to unprotect spreadsheets that I
read in and they all have one of two passwords. Is there a piece of
logic that I could use to try one password and if it fails try the
second?

In other words try password 1 and if it fails try password 2 (without
throwing an error on password 1)?

Any help greatly appreciated.

Thanks!

Reply With QuoteReply With Quote