How can I protect formula cells?

[scott-atkinson]

Guys,

I would like to protect formula cells in my worksheet from being deleted, edited, but with out protecting my work sheet.

How can I do it?

 

[qafself]

Hi,

You could only do this by using VBA to prevent changes being saved but you can't stop changes while it is being used without protecting the sheet.

Protection is very weak and anyone with any knowledge can bypass it easily.

Ed