Using 'Delete' key without deleting

Hello all,

What I am trying to do is:

• User is on A1
• Presses 'Delete' / 'DEL'
• Contents of A1 remains but a window appears asking if they would like to delete entire row
• If user chooses 'Yes', it doesn't delete but strikes through the row

I have got it all except for code to stop the cell being delete when the key is pressed, is there such a code.?



Thanks in advance.

Thanks cytop....

User presses <Delete> key on cell A1, code checks to see if cell A1 has changed and if it is blank. If it is blank it calls up 'Row.Clear';

Please Login or Register  to view this content.

'Row.Clear' calls up a window and the user has two buttons, <yes> and <no>. If <yes> is chosen, the following code is used;

Please Login or Register  to view this content.

As it is at the moment, when <delete> is pressed, the contents of the cell is deleted before the script is run - I don't want that to happen.
Is it the same code as above and how do I merge that code into the above.?


Thank you again.

There's a difference in the approach. Yours' is reactive - you allow the change and then manipulate the cells. A simple

Please Login or Register  to view this content.

in the right place (I didn't look to see where that is...) should do it.

If you want a different approach, the code I posted is proactive - it stops the Delete key from actually deleting the data in the first place...