| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sheet Protection / Edit Objects
I have a spreadsheet with multiple objects that I'm trying to lock. My problem is I also have cells that I need to have comment insertion capabilites. When going to Tools/Protection/Protect Sheet and allow Edit Objects is checked I can insert a comment. However, it also allows the other objects on the sheet to be accessed. Is there a way to allow the Edit Objects option in a specified range of cells and still protect the sheet?
Perplexed.... Keyrookie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! Ungrouping Excel Charts -- EMF/WMF. Can't edit objects in 2007 (Freeform issue). Steve Rindsberg? | Charts and Charting in Excel | |||
| Ungrouping Excel Charts -- EMF/WMF. 2007 can't edit objects as 2003 (freeform big issue). Steve Rindsberg help! | Charts and Charting in Excel | |||
| protection / edit ranges | Excel Discussion (Misc queries) | |||
| Allow users to edit ranges for VBA objects | Excel Worksheet Functions | |||
| I can't select/edit objects. It says [Group] on the header bar. | Excel Discussion (Misc queries) | |||
Linear Mode
