Locking non blank cells in range

Hi all,

I have a worksheet where columns A:C are locked and the sheet password protected. The user enters info into cells in columns D and E (unlocked). The cells in columns D and E are blank but may have a validation list attached.

Now when the user hits a "process" button, part of my script will be to lock any cells in columns D and E that are no longer blank, therefore stopping overwriting of cells at a later date. I know how to password unprotect and protect using VB, but i'm not sure of the script for locking cells that are no longer blank in a range (column D:E).

Any help would be much appreciated, as always on this site!

Thanks in advance.

Chris

Thanks for the quick replies guys. I can't use your method raypayette because the cells that are non blank will be randomly dispersed through the column. Plus the user shouldn't be deciding what area to lock, that has to be determined on his/her entries.

I tried the F5 method Noob but it just gave me "Go To" - I'm not super good at VB so am i missing something?

Thanks.
Chris

I think i should have explained myself a bit better - i'm crap at explaining stuff.

Basically i need script to turn non-blank cells in columns D and E to locked.

That was better

Hi,

Using The F5 method:

click on F5, bottom left of the caption which appears you will see "Special...",
click on this and then choose "constants"

TDV

Yep - definately a whack with the thickie stick. Had the sheet protected so didn't notice the special tab after pressing F5

Thanks for the help all.

Chris