Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an excel worksheet that is used to calculate chemical quantities. The
worksheet needs to have all the cells with formulas completely locked - so no one can delete/change the contents of the cell. I actually have a very(relatively) small range of cells that I want to have available for data entry... How can I prevent the entire sheet from being edited - and only allow data entry into specific cells? I don't know how to attach a copy of the worksheet to show you - but I could possibly email it if needbe. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Un-Protecting a Worksheet | Excel Discussion (Misc queries) | |||
Locking portions of a formula | Excel Worksheet Functions | |||
protecting the worksheet | Excel Worksheet Functions | |||
Protecting Worksheet | Excel Discussion (Misc queries) | |||
Copying portions of data | Excel Discussion (Misc queries) |