View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bobby[_4_] Bobby[_4_] is offline
external usenet poster
 
Posts: 53
Default Returned position address on protected sheet

I have a protected sheet with unprotected cells. If the user Click on a protected cell, the returned target is always the first unlock cell position or address. How can I verify that the target value is lock? Here is the code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("E1:F" & lastrow)) Is Nothing Then
something.....
End If
End Sub

Thank's ahead