Hi,
I'm trying to prevent the user from playing with A1:AB1. I've tried protecting that range but it's seems like a hassle to unprotect when macro runs/protect when macros ends and protect first time user opens the workbook.
I've opted for the Worksheet_SelectionChange option which is fine by me however I run into a problem when user selects a column or the entire sheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row = 1 Then
Target.Offset(1, 0).Select
End If
End Sub
I understand I can't offset the row in these situations but I can't find the code to modify it. Say offset by one row when users selects column but let the user select the whole sheet. Any ideas ?
Thanks,
amphi
Bookmarks