Checking the Value of a Password 1

[rschneeg]

I've protected an excel sheet with a password. I know the old value and have successfully unprotected it to run some macro on the form.

I now want to be able to change the password in vb from the old value to the new.

How do I check the value of the current password to see if it's the old one or the new one?

I know how to protect and unprotect using the ActiveSheet. Protect.Password but do not know how to do an IF statement to see which one it is.

thanks

 

[SkipVought]

Hi,

You can't. Otherwise it would be a trivial matter to crack a password.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TonyJollans]

If you know the password is one of two, it should be trivial to try them both to see which one works.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[fumei]

Except you can not trap any error in the traditional sense. If you "try" one, and it is wrong, there is a run-time stoppage.

faq219-2884

Gerry
My paintings and sculpture

 

[Gavona]

Gerry, with sheet protection in Excel 2003 - this works for me

Sub Macro2()
On Error Resume Next
    ActiveSheet.Unprotect Password:="test2"
    ActiveSheet.Unprotect Password:="test"
End Sub

Gavin

 

[fumei]

I stand corrected...so it does. The On Error line makes it work. Duh. Time to go home...

faq219-2884

Gerry
My paintings and sculpture

 

[rschneeg]

Thanks to all who replied.
The ON ERROR works perfectly.
Rick