Results 1 to 12 of 12

check box to lock cells, date stamp and hide itself after checking

Threaded View

niks check box to lock cells, date... 11-16-2010, 08:21 AM
royUK Re: check box to lock cells,... 11-16-2010, 08:50 AM
niks Re: check box to lock cells,... 11-16-2010, 09:02 AM
davesexcel Re: check box to lock cells,... 11-16-2010, 09:05 AM
niks Re: check box to lock cells,... 11-16-2010, 09:17 AM
royUK Re: check box to lock cells,... 11-16-2010, 09:10 AM
niks Re: check box to lock cells,... 11-16-2010, 09:19 AM
royUK Re: check box to lock cells,... 11-16-2010, 09:22 AM
niks Re: check box to lock cells,... 11-16-2010, 09:39 AM
davesexcel Re: check box to lock cells,... 11-16-2010, 09:34 AM
royUK Re: check box to lock cells,... 11-16-2010, 09:50 AM
niks Re: check box to lock cells,... 11-16-2010, 10:17 AM
  1. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Re: check box to lock cells, date stamp and hide itself after checking

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1