Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want it so that you can not enter ANYTHING in a cell with a formula.
I've tried a bunch of locking/protecting things and can't get the sheet to prevent entry in a cell with a formula. If there is a way I'd appreciate a step by step explanation. Clearly I don't understand the process. office 2003 excel Thanks John Nigel wrote: By default cells are 'Locked' but are only protected when you protect the worksheet as a whole. If you want users to enter data into empty cells then 'Unlock' the cells first then protect the sheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
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) |