Exclude column J from locking

[var]

Hi am back again with another problem

i use below code to lock cells with entry. Now I want to leave J column free from locking. Meaning, I would like to lock every cell which has entry except J column.

Code is

Please Login or Register  to view this content.

any suggestion.. thanks

var

[Winon]

Hello var,

You have provided us with only a snippet of your Code, so I will suggest you try:

Please Login or Register  to view this content.

HTH

[var]

thanks friend,, simple and it worked..:-)

[Winon]

Good!

You are welcome.

Glad I could help