I am using a highlight active row on my worksheet by VBA code :
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("a8:cu200")) Is Nothing Then
Range("cx5").Value = Target.Row
End If
End Sub
And using the conditional formatting rules manager :
Unfortunately when I protect the sheet with password "1234" from Review section (protect sheet) , I get the below message and the highlight row order stopped to work
Thank you in advance to help me to solve this issue.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("a8:cu200")) Is Nothing Then
Range("cx5").Value = Target.Row
End If
End Sub
And using the conditional formatting rules manager :
Unfortunately when I protect the sheet with password "1234" from Review section (protect sheet) , I get the below message and the highlight row order stopped to work
Thank you in advance to help me to solve this issue.