How to Lock a Row

[Shytott]

Hi

Is it possible to lock a ROW (ie prevent users from changing entered data) from cols DQ:RZ depending on whether there is an “x” in col CA (of the same row).
This is to start at row 14 and would end at row 380. Could you also show how to lock the entire row – as opposed from DQ:RZ.
Apologies if this turns out to be VB. Im sure I will be told!

Many Thanks

[Bob Phillips]

Untested

Please Login or Register  to view this content.

[Shytott]

Hi Bob

Thanks for that. Ive tried entering your code onto the relevant sheet, but nothing happened. I tried with the sheet protected and unprotected.
This is basically going to follow the months of the year so with DQ14 being 1st Jan therefore my first 'Lockout' of the year would have covered DQ14:RZ45. Sorry, my appreciation of coding isnt that advanced. Would you code cover this type of action?

Cheers
Supdem

[Bob Phillips]

You have to enter a value in CA to trigger it.

[Shytott]

I have. There are "x"s all the way down to 30th September in CA14:CA287.

Its coming back with a Compile Error, "Ambiguous name detected: Worksheet_Change", and the top line of your code is highlighted.

Supdem

[Shytott]

Ahhhh - I have discovered that cols QO:UU are now mysteriously locked! Is that significant?

Regarding the Compile error, I have another bit of code with the exact same first line, so I presume Excel didnt like that. I changed yours to read "....Worksheet_Changed". Will it still work?

Supdem

[Bob Phillips]

Nope, you have to merge them.

[Shytott]

Hi Bob

Ive mereged the two routines so that they dont crash out, but its still not locking the row or part of the row.

Supdem