Issue with Code Unprotecting Password Protected Sheet

[USFengBULLS]

Hello all,
I am having an issue now when I run my code to uprotect a password protected Sheet and run the code. My code is attached to an ActiveX control button and is simply this:

Private Sub ComboBox1_Change()


ActiveSheet.Unprotect (My Password)
'my code
ActiveSheet.Protect (My Password)
End Sub

After I protect the sheet with the My Password it says my password is not correct.
The real password Consists of four uppercase letter, followed by four numbers. Yes I checked my caps lock.

This was working before but is now all of the sudden not working.
Anyone know what may be going on here?

 

[Col Delane]

Why do you need to unprotect the worksheet before running your code?

If you include

UserInterfaceOnly:=True

as one of the arguments in the

ActiveSheet.Protect (My Password)

line, your code should work without having to first unprotect the sheet.