Unprotect use 2 passwords possible??
 

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!

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!

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!