Object variable or With block not defined

[Cunning]

I keep getting runtime error 91 Object Variable or With block not defined for the following VBA.

Private Sub CommandButton1_Click()

ActiveSheet.Unprotect Password:=TextBox1.Text

Unload Me

End Sub

How can I rectify this?

 

[Cunning]

Sorry Andrew, I realised that was a bit of an erroneous statment as soon as I sent it.

The userform is very basic, with a text box (textbox1) and a command button (OK).

It has to be a userform as obviously the password needs to be hidden characters and I'd rather people got access via the click of a button on the sheet rather than trawling through the menu's as the password resets on sheet activation and it could become too cumbersome.

 

[Andrew Poulsom]

Well as I said I can't reproduce that error, and I can't imagine why it would occur on that line for one user but not others.