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 / New Users / December 2006

Tip: Looking for answers? Try searching our database.

IS IT POSSIBLE TO LOCK THE SHEET BUT PARTIALLY

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shariq - 21 Dec 2006 12:13 GMT
I'd like to know if it is possible to only enable certain cells or parts in
the workbook, where you can write and rest, especially parts where you have
put formulas, to be locked,or make it skip on those cells, or for that matter
the rows.
Is anybody familiar with this kind of stuff, I'd apreciate any suggestions.
Paul B - 21 Dec 2006 12:43 GMT
Shariq,

By default all cells in excel are protected or locked, select the cells you
want to unlock and go to format, cells, protection and uncheck locked, then
go to tools, protection, and protect sheet, enter a password if you want,
now only the cells that you unlocked  can be edited. Be aware that this
protection is very easy to break, the code to do so can be found very easy,
but it will work for most people .

If you only need a few locked I would select them all first, Ctrl A, then
go to format, cells, protection and uncheck locked, then select the cells
you want to lock and go to format cells and check locked, the go to tools,
protection, and protect sheet, enter a password if you want, now the cells
that you locked can not be edited
Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> I'd like to know if it is possible to only enable certain cells or parts
> in
[quoted text clipped - 5 lines]
> Is anybody familiar with this kind of stuff, I'd apreciate any
> suggestions.
 
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.