Ms.Excel Tips Lock and Protect Cells Containing Formulas

Ms.Excel Tips Lock and Protect Cells Containing Formulas

You may want to let users change cells containg data without providing
them access to change formulas. You can keep cells containing formulas
under lock and key without having to protect your entire sheet or
workbook.

When we create a spreadsheet, most of us need to use formulas of some
sort. Sometimes, however, you might not want other users to tamper/
delete/overtype any formulas you included on your spreadsheet. The
easiest and most common way of barring people from playing with your
formulas is to protect your worksheet. However, protecting your
worksheet doesn't just prevent users from tampering with your
formulas, it also stops users from entering anything at all. Sometimes
you do not want to go this far.


Read more:
https://sites.google.com/site/excelknowitall/home/chapter-9
.

Relevant Pages

  • RE: Looking for security
    ... Protecting specific worksheet or workbook elements ... When you protect a worksheet, all cells on the worksheet are locked by ... Select locked cells Moving the pointer to cells for which the Locked check ...
    (microsoft.public.excel)
  • Re: Allow user
    ... To protect the VBA code, in the VBA Editor go to the Tools menu, choose ... Dim UName As String ... ' UNameLen-1 characters. ... ' Lock all cells. ...
    (microsoft.public.excel.programming)
  • Re: Allow user
    ... To protect the VBA code, in the VBA Editor go to the Tools menu, choose ... Dim UName As String ... ' UNameLen-1 characters. ... ' Lock all cells. ...
    (microsoft.public.excel.programming)
  • Re: Multiple Sclerosis: The mercury/parasites model
    ... Selectively Blocking Inflammatory Signals May Protect Mice From MS ... A new way to preserve the cells that surround and protect nerves could ... "Interferon-gamma is not normally found in the nervous system," said ...
    (alt.support.mult-sclerosis)
  • Possible Target Of Immune Attack In MS And New Therapeutic Approach Identified By National MS Societ
    ... small protein normally produced by cells to ... Cells have built-in defenses ... and previous studies have shown CRYAB to be present in MS ... the body to protect against harm may itself become the target of the ...
    (alt.support.mult-sclerosis)