ExcelBanter - PROTECT FORMULA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - PROTECT FORMULA (https://www.excelbanter.com/excel-discussion-misc-queries/233736-protect-formula.html)

Donna

PROTECT FORMULA

I want to protect the formulas in the worsheet so that they can not be
deleted or changed.

Gord Dibben

PROTECT FORMULA

See help on sheet protection and protecting individual cells.

Basics are you lock the cells you don't want edited then protect the
worksheet with a password.

Just be aware that Excel internal security is very weak and passwords easily
cracked.

But to protect cells from inadvertant change it is sufficient.

Gord Dibben MS Excel MVP

On Fri, 12 Jun 2009 15:17:01 -0700, Donna
wrote:

I want to protect the formulas in the worsheet so that they can not be
deleted or changed.

All times are GMT +1. The time now is 10:23 PM.