Re: lock only formulas, not worksheet
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Before applying the protection, you must first unlock the cells which
you want the User to be able to adjust (using Format | Cells |
Protection tab). Then when you use Tools | Protection only the
remaining Locked cells will be affected.
If you are using XL 2000 then once the sheet is protected you can not
add or delete rows.
Hope this helps.
Pete
On Jan 18, 5:20 pm, ericaamousseau
<ericaamouss...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am making a very complex spreadsheet for a co worker and I would like only
the formulas to be locked. I would like my co worker to still be able to
change the color of cells and add or delete rows (even rows thathave my
formulas) When I do protect the worksheet the way I usually do it rows can
not be adjusted at all. any suggestions?
.
Relevant Pages
- Re: OOL X - The origin of the RNA world.
... Protection from too-harse conditions that occur on ... and from prokaryotes to nucleated cells" by William ... > membranes in the archaebacterial and fatty acid ester membranes in ... life experienced an "explosion", ...
(sci.bio.evolution) - Re: Import error message
... these cells as though they had data in them. ... Select the first row below your last row with data ... If protection was set, ... The second possibility is that the worksheet or workbook is protected. ...
(microsoft.public.access.externaldata) - Re: what does this error message mean
... these cells as though they had data in them. ... Open the sheet in Excel, ... If protection was set, ... The next possibility is that the worksheet or workbook is protected. ...
(microsoft.public.access.externaldata) - Re: what does this error message mean
... these cells as though they had data in them. ... Open the sheet in Excel, ... If protection was set, ... The next possibility is that the worksheet or workbook is protected. ...
(microsoft.public.access.externaldata) - Re: Error when importing Excel file
... >these cells as though they had data in them. ... An alternative to resetting the UsedRange is to define a named range of ... If protection was set, ... The next possibility is that the worksheet or workbook is protected. ...
(microsoft.public.access.externaldata) |
|
