MAcro to lock and unlock cells depending on rows selected.

Hi all,

I have a excel sheet where depending on the value of a column in each row i must make some cells locked and others unlocked.

so i have the following code:

Please Login or Register  to view this content.

This is working fine.
But only for ROW 11.
But now depending on the row selected i want to make the columns of the corresponding rows Locked. how can i do it?

Thanks
Glen.

try

Please Login or Register  to view this content.

No Jindan,

It's not locking the columns at all.

-Glen.

Originally Posted by ballack

No Jindan,

It's not locking the columns at all.

-Glen.

If you look at your code, where are you locking any cell?
The following line is the only one that you are locking

Please Login or Register  to view this content.

However, you are unlocking in the next line

Please Login or Register  to view this content.

What do you want to do?

I am sorry Jindon your code is working.
I had to change the lock=true.

Thanks a lot for your help.

Glen.

Hi all,

If i want to lock the cells in corresponging Row in other sheets alos , then how can i achieve it?


Thanks a lot once again.
Glen.

can anyone help me on this?