Take a look at setting the Protection on the cell range then protecting the
sheet and workbook. You can choose if the user can select or not the
protected cells.

If you in addition you also need to move the cursor to Cell A1 then put a
selection event in the worksheet code.

--

Regards,
Nigel




"K" wrote in message
...
Hi, I want a macro that if I try to activate cell or try to select
any cell in Range("C1:D10")
then cell "A1" should be selected or get activate. Basically I am
trying to lock the Range("C1:D10") that
if I or someone else select any cell in Range above then cell "A1"
should get selected
like this nothing can be edit in Range above. I hope I explained what
I am trying to
say. Please if anybody can give me help in this.