Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 391
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 391
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allowing editing locked cells in a protected sheet in excel phoenix[_2_] Excel Worksheet Functions 1 December 23rd 08 11:50 AM
How to check previous entries in column for same contents Emily Excel Worksheet Functions 4 July 30th 08 10:56 PM
Changed default font, previous font still shows when editing Font/Editing Problem Excel Discussion (Misc queries) 1 May 19th 06 12:46 PM
Changed default font, previous font still shows when editing Font/Editing Problem Excel Discussion (Misc queries) 0 May 18th 06 04:37 PM
Can't Edit Contents of Protected Worksheet Phil-in-SF Excel Discussion (Misc queries) 0 May 1st 06 11:37 PM


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"