ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CELL PROTECTION (https://www.excelbanter.com/excel-worksheet-functions/75856-cell-protection.html)

Henry

CELL PROTECTION
 
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

Peo Sjoblom

CELL PROTECTION
 
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




All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com