PDA

View Full Version : How to stretch some range, if in contains some protected cells?



jiura
04-22-2008, 04:34 AM
Hello!
I have Excel Sheet and On sheet and have two types of cells: protected and non-protected. For example rows 1 and 3 are no-protectect, and 2-nd is protected. My user doesn’t see 2-nd Row – it’s hide.
When he entered some data into 1-st and 3-rd row he wanted to “stretch” his datato the right with small little point in right bottom corner of this range (selected range consist of one cell in first, second and third row). But Excel don’t allow to do this. Excel show message, that this range contain some protected cells and may’not be stretch. Can I do something, that may allow user to do such selection and copy (“stretch”) valuу шт no protected cells to the future: protected cells could be selected but not change.


Thanks to all.

jazznaura
04-22-2008, 10:21 AM
hi,

Can’t you move the data in the second row to another row permanently?
Would help if you attached the workbook.