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