Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to permit editing the contents of added row(cells) if previous row is protected?
2007
Is there an approach to enable cell editing to the cells in an added row if the above cells are locked and the w/s protected? My point, can OK the addition of rows to a protected w/s. That said, the cells in that new row cannot be edited because the inserted row (cells) inherits the protection formatting characteristic from the cells above the inserted row. TIA EagleOne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to permit editing the contents of added row(cells) if previous row is protected?
Another question:
Looking at the Properties Window of the VBA editor I find a Property EnableFormatConditions = True or False I cannot find an explanation as just what this property is. Does anyone know that answer? TIA EagleOne wrote: 2007 Is there an approach to enable cell editing to the cells in an added row if the above cells are locked and the w/s protected? My point, can OK the addition of rows to a protected w/s. That said, the cells in that new row cannot be edited because the inserted row (cells) inherits the protection formatting characteristic from the cells above the inserted row. TIA EagleOne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing editing locked cells in a protected sheet in excel | Excel Worksheet Functions | |||
How to check previous entries in column for same contents | Excel Worksheet Functions | |||
Changed default font, previous font still shows when editing | Excel Discussion (Misc queries) | |||
Changed default font, previous font still shows when editing | Excel Discussion (Misc queries) | |||
Can't Edit Contents of Protected Worksheet | Excel Discussion (Misc queries) |