RE: Prevent Row deletion ?

[Dhimit]

RE: Prevent Row deletion ?

Hello,

Is there a way to prevent deletion of rows in a worksheet & allow everything else i.e insert, update etc,etc.

i tried this using Tools > Protect > Protect Sheet by only ticking 'Delete Rows' but this stops me from doing EVERTHING ?!

Dhimit

 

[brian.wethington]

Tick everything you want to allow... untick things you wish not to allow

 

[Dhimit]

RE:

everything is 'CHECKED' EXCEPT 'Delete Row/Column'
but still CAN'T enter any data

DC

 

[brian.wethington]

sorry, figured you already had the cells unlocked.....

select your range of cells you wish to allow to be changed and choose the format menu, selecting cells and click the protect tab. uncheck the locked box. and click ok. Sorry for the confusion.

 

[xenou]

I haven't studied this carefully but it might help:
http://www.dailydoseofexcel.com/archives/2006/08/21/capture-deleted-rows/