title: How do I lock one cell without locking sheet? I have two signatures that need to happen at different times
body: <p>I have an excel worksheet that has to be signed off on twice and neither reviewer can have the password. I can get the the whole worksheet to lock after the first signature but then the second person can't sign. I'd like to lock cell range F2:K2 after the first signature and move my worksheet locking script to look for changes to the second signature. I've tried at least 6 approaches and no luck. It keeps wanting to lock the entire sheet. Two ranges: F2:K2 and N2:O2. First user saves the doc with a new name and then second reviewer opens it and signs off in N2:O2</p>
  
  <p>code for first sig F2:K2 that locks everything. I need this cell to lock when saved and leave the worksheet unlocked until the second reviewer signs off. Help!!</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  Dim xRg As Range
  On Error Resume Next
  Set xRg = Intersect(Range("F2:M2"), Target)
  If xRg Is Nothing Then Exit Sub
  Target.Worksheet.Unprotect Password:="PASSWORD"
  xRg.Locked = True
  Target.Worksheet.Protect Password:="PASSWORD"
  End Sub
  </code></pre>