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.

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.

On Jan 30, 11:04*am, "Nigel" wrote:
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.- Hide quoted text -

- Show quoted text -

do you know how what should i do to protect the range of cell as i am
using Excel 2007

Select cells, right click choose Format Cells, select Protection tab, check
Locked.

Then right click sheet tab, choose Protect Sheet, and set level of access,
enter password if required.

--

Regards,
Nigel




"K" wrote in message
...
On Jan 30, 11:04 am, "Nigel" wrote:
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.- Hide quoted text -

- Show quoted text -

do you know how what should i do to protect the range of cell as i am
using Excel 2007