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/36071-cell-protection.html)

Liz - HADC

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

Roger Govier

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




Liz - HADC

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