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 / March 2006

Tip: Looking for answers? Try searching our database.

spreadsheet protection?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chrissywhittle - 16 Mar 2006 13:13 GMT
I would like to be able to change only a few cells within a workbook sa
cells b3/d5 etc…. and the rest of the workbook can not be changed,  
how do I protect it in this way? thank yo
Roger Govier - 16 Mar 2006 13:24 GMT
Hi Chrissy
By default, all of Excel's cells are Locked, but that doesn't become
operative until you apply Protection to the sheet.
So, mark the range of cells you wish to allow alteration and
Format>Cells>Protection> remove the check mark for Locked.
Then Tools>Protection>Protect Sheet> optional whether you use a password
or not, but be sure to remember it if you do give one.

Please note, even with a password, it is not totally secure, as there
are plenty of password removal algorithm's freely available on the web
which will allow the user still gain access to the cells if they are
determined.

Signature

Regards

Roger Govier

"chrissywhittle"

>
> I would like to be able to change only a few cells within a workbook
> say
> cells b3/d5 etc.. and the rest of the workbook can not be changed,   -
> how do I protect it in this way? thank you
Bondi - 16 Mar 2006 13:25 GMT
Hi,

Tools -> Protection -> Allow Users To Edit Ranges -> New

Select the cells you want the users to be able to edit and click
Protect Sheet.

Regards
Martin
AndyB - 16 Mar 2006 13:26 GMT
Hi

By default, Excel's cells are all locked - but remain in use until the
worksheet is protected.
Select the cells you want to use and go to Format/Cells and click on the
last tab, Protection. Uncheck the Locked option. Now you can protect the
sheet by going to Tools/Protection . . Protect Sheet.

Hope this helps.
Andy.

> I would like to be able to change only a few cells within a workbook say
> cells b3/d5 etc…. and the rest of the workbook can not be changed,   –
> how do I protect it in this way? thank you
 
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



©2009 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.