title: Trigger event when select from dropdown
body: <p>I need when a user selects an option from the dropdown menu, it will trigger the event and lock down certain range of cells. I got the codes for lockdown cell but I can't lock it down when I select the dropdown menu. The value of the string data in the dropdown menu is ZFB50</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Target.Address = "$K$2" Then
  
      With Application
       .EnableEvents = False
       .ScreenUpdating = False
       .Calculation = xlCalculationManual
      End With
  
  If Target.Address = "ZFB50" Then
  
      ActiveSheet.Unprotect
  
      Range("E8:E100").Select
      Selection.Locked = True
  
      Range("C8:C100").Select
      Selection.Locked = True
  
      Range("D8:D100").Select
      Selection.Locked = True
  
      Range("F8:F100").Select
      Selection.Locked = True
  
      Next cell
  
      ActiveSheet.Protect
  
      With Application
       .EnableEvents = True
       .ScreenUpdating = True
       .Calculation = xlCalculationAutomatic
      End With
  
  End If
  
  End Sub
  </code></pre>
  
  <p>It still doesn't work, is there any problem with this code?</p>