Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete is Pressed then Stop
Hi All, I am looking for a VBA code that if the delete button is pressed on a particular cell (B1 - B100), on a worksheet, that a code will stop it. Something like this; Private Sub Worksheet_*BeforeDelete(*ByVal target As Excel.Range) msgbox("cell can not be deleted") end sub Please Help Lenny -- Lenny_821 ------------------------------------------------------------------------ Lenny_821's Profile: http://www.excelforum.com/member.php...o&userid=15179 View this thread: http://www.excelforum.com/showthread...hreadid=268122 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a COMMAND to stop a current process in Excel(Copy/Delete/ | Excel Discussion (Misc queries) | |||
How to stop a Control Button moving when I delete columns(Excel) | Excel Discussion (Misc queries) | |||
Delete macro to stop importing data | Excel Programming | |||
Which button was pressed? | Excel Programming | |||
Trapping key pressed in a worksheet | Excel Programming |