Thank you for your reply. I found the Lock property in Format Cells. But
when I add protection -- the Locked Cells and unlocked cells are checked by
default. I also noticed that all the cells are checked as locked by default.
Is there a setting somewhere to make the cells unlocked by default?

When I protect the sheet - I cannot edit any of the cells. How can I secure
only specified cells while I can still edit other cells in a given sheet?

Thank you.

"Tom Ogilvy" wrote:

each cell has a locked property. when the sheet is protected (not the
workbook), each cell who has it locked property selected is protected.

--
Regards,
Tom Ogilvy


"Rich" wrote:

Hello,

Is it possible to lock/secure individual cells with VBA code so that
contents can't be changed? Specifically - formulas? Or am I restricted to
password protecting the entire workbook (read only mode)?

I would like to be able to enter data without having to unprotect the
workbook each time, but protect cells that contain formulas. Any advice
appreciated on the best way to secure my project with the least amount of
inconvenience.

Thanks,
Rich