This for the controls checkbox
![]()
Private Sub CheckBox1_Click() If Me.CheckBox1 = True Then With Me .Unprotect .Range("E7:E13").Locked = True .Range("I13") = Now CheckBox1.Visible = False .Protect End With Else 'don't? End If End Sub
This for the controls checkbox
![]()
Private Sub CheckBox1_Click() If Me.CheckBox1 = True Then With Me .Unprotect .Range("E7:E13").Locked = True .Range("I13") = Now CheckBox1.Visible = False .Protect End With Else 'don't? End If End Sub
Last edited by davesexcel; 11-16-2010 at 09:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks