Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to protect some cells in a sheet so the equation won't be changed.
How do I just protect certain cells, and not the whole sheet. Any help would be greatly appreciated. Thanks, Henry |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select the whole sheet (click the select all button above 1 left of A or
press ctrl A), do formatcellsprotection, uncheck locked, now select all the cells that you want to protect and repeat but select locked for those cells, when that is done do toolprotectionprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Henry" wrote in message ... I need to protect some cells in a sheet so the equation won't be changed. How do I just protect certain cells, and not the whole sheet. Any help would be greatly appreciated. Thanks, Henry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell protection based on a formula | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
cell protection | Excel Discussion (Misc queries) |