Formulas
 

I created a worksheet for work and input a formula to add up several
different cells for us and I would like to know if there is a way to protect
just the formula but still let other people be able to change the numbers as
they change three different times per shift for three shifts.

Formulas
 

Hi

all cells in a sheet have their FormatProtection property set to Locked by
default.
As soon as you apply ToolsProtectionprotect sheet the cells will be
protected.

All you need to do is format the cells where you want Data entry to take
place to be not locked (remove check mark from Locked), then apply sheet
Protection.

--

Regards
Roger Govier

"Derf" wrote in message
...
I created a worksheet for work and input a formula to add up several
different cells for us and I would like to know if there is a way to
protect
just the formula but still let other people be able to change the numbers
as
they change three different times per shift for three shifts.

Formulas
 

By default, the cells in a worksheet are set as "Locked", but this
does not become active until you protect the sheet. However, as you
only want to protect one cell, it would be better to unlock all cells
and then lock the cell with your formula in.

Click on the grey square at the intersection of the row and column
identifiers (which will highlight all cells in the worksheet), then
click on Format | Cells | Protection tab, then uncheck Locked and
Hidden and click OK. Then click on the cell with your formula in and
Format | Cells | Protection tab, then check Locked (and maybe Hidden,
depending on whether you want your employees to see the formula), then
OK.

Then click on Tools | Protection | Protect Sheet and check the options
you require - the password is optional, but if you give one then you
will be asked to repeat it (make a note of it, as well). Now you will
be able to type in any cell except for the one containing your
formula.

Password protection is not very secure in Excel, but it will probably
suffice in this instance.

Hope this helps.

Pete



On Dec 8, 12:07 am, Derf wrote:
I created a worksheet for work and input a formula to add up several
different cells for us and I would like to know if there is a way to protect
just the formula but still let other people be able to change the numbers as
they change three different times per shift for three shifts.