 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Lock Cells with a Forumlae
How can I lock cells in an Excel 2003 template such that cells with formulae cannot be edited or have data entered into them? Thanks! Select the cells that should be locked and then use: format|cells|protection tab|check lock Select the cells that should be unlocked and uncheck that setting. Depending on the number of cells of each type, it may be easier to lock (or unlock) all the cells and just unlock (or lock) the others. Then you have to protect the worksheet Tools|Protection|Protect sheet (give it a nice password) Be aware that this kind of protection is easily broken and that there are lots of things that are unavailable on protected sheets. You may want to do some testing to see it still fits your requirements. > How can I lock cells in an Excel 2003 template such that cells with > formulae cannot be edited or have data entered into them? Thanks!  SignatureDave Peterson Thanks, Dave. Simple security is fine. The primary objective is to keep users from accidentally typing a number over a formula. > Select the cells that should be locked and then use: > format|cells|protection tab|check lock [quoted text clipped - 15 lines] >> How can I lock cells in an Excel 2003 template such that cells with >> formulae cannot be edited or have data entered into them? Thanks! When I want this kind of protection, I won't supply a password to the worksheet protection. Most(?) users don't know how and won't want to unprotect the sheet. > Thanks, Dave. Simple security is fine. The primary objective is to keep > users from accidentally typing a number over a formula. [quoted text clipped - 18 lines] > >> How can I lock cells in an Excel 2003 template such that cells with > >> formulae cannot be edited or have data entered into them? Thanks! SignatureDave Peterson
|
Reply to this Message |
 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.