#1   Report Post  
Liz - HADC
 
Posts: n/a
Default 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
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default

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



  #3   Report Post  
Liz - HADC
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation, cell protection or other method? KG Excel Discussion (Misc queries) 5 June 17th 05 05:22 AM
Cell Protection Issue Ket Excel Worksheet Functions 1 May 11th 05 01:10 AM
cell protection D Excel Discussion (Misc queries) 2 March 29th 05 10:58 AM
Conditional formating - cell protection Bdavis Excel Discussion (Misc queries) 0 February 11th 05 09:15 PM
Cell Protection Color Kmagg Excel Discussion (Misc queries) 4 February 10th 05 05:46 PM


All times are GMT +1. The time now is 01:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"