Establish the Unprotect Password

[jrheeder]

Hello,

I recently sent out about 200 workbooks, half with one protect password and the rest with another (for this purpose we will make the passwords passA and passB). What I am trying to do via Excel macro is establish what password that sheet is using.

Now I have tried

If IsError(ActiveSheet.Uprotect ("passA")) = False then
...
else if IsError(ActiveSheet.Uprotect ("passB")) = False then
...
end if

Now of course this doesn't work... any advise?

Regards,