Lock or unlock cell in vba

i have a 2 particulary large sheets of data (something like 640 rows by 52 columns on each sheet) and need to protect the sheet so that the users cannot edit / alter any cells that contain formula's, however, they can edit any cells that do not contain formulas.

there are far too many cells to manually check, lock or unlock and then protect the sheet.

i know the cells can be locked or unlocked in vba using

Cells(x, y).Locked = False

however, i have no idea how to check every cell, deterin if it contains a formula (and lock it) or if it does not contain a formula (and unlock it), so i am looking for some advice on how to proceed.

any help would be gratefully appreciated

Hi Noob,

THANKS FOR THAT its perfect,

i never dreamt that the code could be so simple as one line!

is there a good book / helpfile that would give this information.

once again,thanks, you saved me hours!!!!!!!!!!!

once again thanks, so much to learn, so many ways to improve.