#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henry
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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


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
cell protection based on a formula AJPendragon Excel Worksheet Functions 0 February 26th 06 09:16 AM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
Data validation, cell protection or other method? KG Excel Discussion (Misc queries) 5 June 17th 05 05:22 AM
cell protection D Excel Discussion (Misc queries) 2 March 29th 05 10:58 AM


All times are GMT +1. The time now is 01:04 PM.

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

About Us

"It's about Microsoft Excel"