 |
 | 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 / Worksheet Functions / September 2007Protected Range Not Protected
I have a workbook I inherited. I set up a range to protect so that the cells are editable when the sheet is protected. But even when protected there are other cells that are not protected. I did not specify them and do not see them in the list of ranges that are excluded from protection. So how to do I turn off this lack of protection so these cells are now protected? I could delete the rows and recreate them and this MIGHT work, but I wanted another solution, if possible. Mike, By default all cells in a worksheet are protected but this is only activated when the sheet is protected. It sounds like some of this deault setting may have been changed so:- Select all cells and click Format|Cells|Protection and un-check and re-check locked, Then select any cells you want users to edit and repeat the above leaving the locked box un-checked. Protect the sheet. Mike > I have a workbook I inherited. I set up a range to protect so that the cells > are editable when the sheet is protected. But even when protected there are [quoted text clipped - 3 lines] > delete the rows and recreate them and this MIGHT work, but I wanted another > solution, if possible. That was the problem. Thanks, Mike. |
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.