PDA

View Full Version : Is there a setting to warn before deleting a cell?



frank_m
10-03-2010, 10:26 PM
Is there any setting that I can make to warn the user before shifting cells after clicking delete? I see there is one when inserting during a copy-insert-paste, but my Excel gives no warning when deleting a cell, resulting in my surrounding row or cell data becoming corrupted.

Doing this type of check in the change event will not work because some times the accidental insertion happens when events are disabled or when in design mode.

Thanks in advance