Skip lock based on cell value

[MP1286]

Hi,

I've sourced a code online for locking cells based on value but it seems to lock the cells above that aren't equal to the value.

I combined it with my code to essentially add the date to column L and then lock the cell in column K to prevent someone from editing it and the sequence running again and overriding the value in column L.

Please Login or Register  to view this content.

Any help understanding why it is locking cells above it if they are filled with any value will be much appreciated. Equally, any help simplifying the code would also be appreciated.

ty

[Tsjallie]

The core of your problem is in this line:

Please Login or Register  to view this content.

RangeToLock = K8:K1000 and SpecialCells(2) looks at cells with literal data.
This means that all cells in the range K8:K1000 having literal data will be locked.

Actually the only piece of code you need is this (I think):

Please Login or Register  to view this content.