Cell Protection
I would like to protect only certain cells within the Excel work book. Does
anyone know how to do this? The help menu only tells how to protect the complete work book/work sheet. Any help would be appreciated |
Hi Liz
You need to select the range of cells that you don't want to be protected, then go to FomatCellsProtection and deselect the Protect button. Then, when you Protect the sheet, those cells will remain unprotected. -- Regards Roger Govier "Liz - HADC" <Liz - wrote in message ... I would like to protect only certain cells within the Excel work book. Does anyone know how to do this? The help menu only tells how to protect the complete work book/work sheet. Any help would be appreciated |
Thanks Roger for your help
Liz "Roger Govier" wrote: Hi Liz You need to select the range of cells that you don't want to be protected, then go to FomatCellsProtection and deselect the Protect button. Then, when you Protect the sheet, those cells will remain unprotected. -- Regards Roger Govier "Liz - HADC" <Liz - wrote in message ... I would like to protect only certain cells within the Excel work book. Does anyone know how to do this? The help menu only tells how to protect the complete work book/work sheet. Any help would be appreciated |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com