View Full Version : How can I protect formula cells?


scott-atkinson
09-13-2007, 06:04 AM
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
09-14-2007, 06:41 AM
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