Hi!
I would like to disable the DELETE key whenever a particular sheet is
selected and then reenable it whenever any other sheet is selected.
I have this code in the VBA sheet I want it disabled in.

[start code]
Private Sub disable1()
' This macro disables the Delete key
Application.OnKey "{DELETE}", ""
End Sub
[end code]

If I use this code on all the other sheets it should reenable the key.

[start code]
Private Sub disable2()
' This macro enables the Delete key
Application.OnKey "{DELETE}"
End Sub
[end code]

It does'nt work. What am I doing wrong?
I would be greatfull for any help. Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=502533