Password protect a Checkbox

[IainG]

Can anyone tell me if its possible to password protect a Checkbox?

 

[Alisa]

yes, just put validation in the beforeupdate event.

 

[IainG]

This is the Validation that I have but Checkbox still changes regardless of password!

Private Sub Locked_BeforeUpdate(Cancel As Integer)
If InputBox("You must provide the correct password to Lock or Unlock an Estimate!", "Password Input") <> "Test" Then
MsgBox "Wrong Password Entered. Operation aborted!", vbCritical
End If
End Sub

 

[Alisa]

you need cancel=true within your if statement.
That is what cancels the update.