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!