 |
 | 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 / September 2007Protected Cells
Is there a way to protect certain cells, in a spreadsheet, so that the user cannot modify (destroy) the formulas? Thanks Just use regular protection. Before you protect the sheet, right..click on the cells you want the user to be able to modify and select Format Cells. Uncheck the Locked box. Now, when you protect the sheet, only those cells that are unlocked will be able to be edited. > Is there a way to protect certain cells, in a spreadsheet, so that the user > cannot modify (destroy) the formulas? > Thanks Yes this works great... thanks. > Just use regular protection. Before you protect the sheet, > right..click on the cells you want the user to be able to modify and [quoted text clipped - 5 lines] >> cannot modify (destroy) the formulas? >> Thanks |
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.