Results 1 to 7 of 7

Lock an entire row

Threaded View

kid_epicurus Lock an entire row 04-19-2012, 04:23 PM
JBeaucaire Re: Lock an entire row 04-19-2012, 04:58 PM
kid_epicurus Re: Lock an entire row 04-19-2012, 05:04 PM
xladept Re: Lock an entire row 04-19-2012, 05:15 PM
JBeaucaire Re: Lock an entire row 04-19-2012, 06:13 PM
kid_epicurus Re: Lock an entire row 04-20-2012, 10:05 AM
JBeaucaire Re: Lock an entire row 04-20-2012, 12:33 PM
  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Knoxville, TN
    MS-Off Ver
    Excel 2010
    Posts
    18

    Lock an entire row

    Currently I have this code, but it's not working. I'm not sure what to use to lock an entire row. Seems like this would do it.

    Private myCheckbox_Click()
        If myCheckbox.Value = True Then
            Me.Range("C205:I205").EntireRow.Locked = False
        Else
            Me.Range("C205:I205").EntireRow.Locked = True
        End If
    End Sub
    Last edited by kid_epicurus; 04-19-2012 at 04:27 PM.

Thread Information

Users Browsing this Thread

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

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