Thread: LOCK THE CELLS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default LOCK THE CELLS

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.