I would like to know how to protect function from change
I would like to know how to protect function from change
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks