Fixed the operation range

[cannny]

Dear all,

I would like to fix the operation range from A1 to K20, prevent operator to disturb other range setting & data, please help to teach how to fix it & back to normal status.


Thanks for help.


Cannny

 

[Yongle]

Protect like this

Select cells A1:K20 \ right-click \ Format Cells \ Protection \ remove X from Locked box \ OK

Right-Click on Sheet Tab \ Protect Sheet \ Insert Passsword \ Confirm Password \ OK


Unprotect like this

Right-Click on Sheet Tab \ UnProtect Sheet \ Insert Passsword \OK


Protect again

Right-Click on Sheet Tab \ Protect Sheet \ Insert Passsword \ Confirm Password \ OK

 

[footoo]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
If Intersect(Target, [A1:K20]) Is Nothing Then
    [A1].Select
ElseIf Target.Count <> Intersect(Target, [A1:K20]).Count Then [A1].Select
End If
Application.EnableEvents = True
End Sub

 

[cannny]

Dear Yongle, footoo,

Thank you very much for teach.

Thanks.