Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection
How do I protect certain cells in a sheet so that users can't overwrite
formulae but allow entries in other cells in the same sheet to be edited? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection
You can lock and unlock cells by selecting them and then
Format|cells|protection tab (xl2003 menus) But that really doesn't do much until you protect the sheet. Tools|Protection|protect sheet (give it a nice password if you want) Be aware that there are lots of things that are disabled on protected sheets. You'll want to test to see if you can live with those restrictions. And don't trust worksheet protection. It's easily broken by anyone who really wants to break it. Mike McLellan wrote: How do I protect certain cells in a sheet so that users can't overwrite formulae but allow entries in other cells in the same sheet to be edited? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection | Excel Discussion (Misc queries) | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Protection | Excel Discussion (Misc queries) |