Can you please tell me where I am supposed to go to type in the information
you provided. I understand the unprotect the sheet but don'tunderstand about
change formatting of re-protect the sheet.

"Per Jessen" wrote:

Hi

You have to unprotect the sheet, change formatting af re-protect the sheet.

Dim LastCell As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Unprotect Password:="JustMe"
If Not LastCell Is Nothing Then
LastCell.Interior.ColorIndex = 0
End If
If Target.Locked = False Then
Target.Interior.ColorIndex = 4
End If
Set LastCell = Target
ActiveSheet.Protect Password:="JustMe"
End Sub

Regards,
Per

"LTOSH" skrev i meddelelsen
...
I was looking for a way to highlight a cell that i am currently going to
type
in. After looking through this forum i have seen the suggestion of
"rowliner". i downloaded it and it is doing what it suggests however, I
desire my worksheet to be protected but it doesn't work once i protect the
worksheet.

what do i do? i only want to highlight cells that are unlocked for the
user
as i tab through the worksheet. make sense??

thanks.
LTOSH