Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

cell protection,  how to?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
S S - 17 Jun 2007 11:16 GMT
How do I protect selected cells for protection in a worksheet?
I have gone to tools and protection but can only seem to protect the full
worksheet, I have tried clicking/unclicking locked and unlocked boxes but
cant seem to get it right.
Stan Brown - 17 Jun 2007 11:39 GMT
Sun, 17 Jun 2007 10:16:27 GMT from S S <nonsense@Hotmail.co.uk>:
> How do I protect selected cells for protection in a worksheet?
> I have gone to tools and protection but can only seem to protect the full
> worksheet, I have tried clicking/unclicking locked and unlocked boxes but
> cant seem to get it right.

There are two layers, cell protection and worksheet protection. By
default every cell is protected but the protection is switched off
for the worksheet as a whole. To protect specific cells you need to
change both those layers, in sequence:

1. Unprotect the cells you don't want to protect (Format | Cells |
Protection).
2. Turn on the protection system with Tools | Protection | Protect
Worksheet.

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
                                 http://OakRoadSystems.com/

Max - 17 Jun 2007 11:44 GMT
Try it in this sequence ..

First, you need to "unlock" all cells in the sheet. Select the entire sheet,
click Format > Cells > Protection tab > Uncheck "Locked" > OK.

Now select only the cells that you want protected (Hold down CTRL to select
multiple cells/ranges). Click Format > Cells > Protection tab > Check
"Locked" > OK.

Then apply sheet protection via Tools > Protection > Protect Sheet >
Password? > OK
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> How do I protect selected cells for protection in a worksheet?
> I have gone to tools and protection but can only seem to protect the full
> worksheet, I have tried clicking/unclicking locked and unlocked boxes but
> cant seem to get it right.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.