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