Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |