Locking formulas

**pixiesoft** · 10-22-2008, 03:52 AM

I have created a costings work book and I want to lock the formulars. I want people to be able to enter data i.e descriptions, costs but I dont want the to be able to alter any formulars. is this possible? I can post the sheet if it would help.

**resulgul** · 10-22-2008, 05:28 AM

Have a look at "Format, Cells, Protection" & "Tools, Protection".
Gives you options to protect cells, worksheet & workbook.

**pixiesoft** · 10-23-2008, 07:36 AM

will this enable data entry and lock the formula?

**jasoncw** · 10-23-2008, 08:05 AM

Here are 2 options.

1. Only lock cells with formulas:

- Select all cells (CTRL + A), Format > Cells > Protection, uncheck Locked, and click OK
- Edit > GoTo, click Special, select Formulas, then click OK
- Tools > Protection > Protect Sheet, and assign a password (or leave blank for no password)

2. Lock all cells, except for the specified cells that you will allow input:

- Select all cells (CTRL + A), Format > Cells > Protection, make sure Locked is checked, and click OK
- Select cells you want to allow input (hold down CTRL while clicking on non-contiguous cells)
- Format > Cells > Protection, uncheck Locked, and click OK
- Tools > Protection > Protect Sheet, and assign a password (or leave blank for no password)

HTH

Jason