Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How protect function inside cell from change
I would like to know how to protect function from change
|
#2
|
|||
|
|||
You need to 'protect' your workbook or worksheet.
By default, all cell have their protection status set to 'locked', but the worksheets are unprotected, so the locking basically has no effect. If you only want to protect a few cells from being changed, then follow this procedure. Hit ctrl+A to select all cells, or click the blank Box in the corner between Column A and row 1. Goto 'Format', 'Cells', 'Protection', and untick the 'Locked' box. Return to your sheet and select the cell(s) you want to lock. Back to 'Format', 'Cells', 'Protection', and tick the 'Locked' box. Now go to 'Tools'. 'Protection', 'Protect Sheet' Supply a password, and select which, if any, actions you will allow your users to perform on locked cells. Click OK, and your cell are now safely locked. (Just don't forget your password) HTH Neil www.nwarwick.co.uk "ytumeh" wrote: I would like to know how to protect function from change |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Excel should have a quick and simple "change case" function like . | Excel Worksheet Functions | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Using the MAX function with "constant increment" cell references | Excel Worksheet Functions | |||
copy a cell value not its function | Excel Discussion (Misc queries) |