keypress interception

[Guest]

Hello everybody!
I need to make available some graphical object for movement on a protected
sheet. So I've protected that sheet in this way:
Foglio.Protect DrawingObjects:=False,
but i need to control the risk of object deletion...maybe "undoing" the
deletion action.
The idea I've in mind is to intercept the DEL keydown once it has been
hitten in order to restore the deleted object...but I don't know how.
Who can help me!?
Thanks in advance

 

[Guest]

See OnKey Method in VBA Help

 

[Bob Phillips]

Add this macro

Sub myProc()
MsgBox "Delete key disabled"
End Sub

then redirect the delete key with

Application.OnKey "{DEL}", "myProc"


You can use

Application.OnKey "{DEL}"

to reset it

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Simply perfect...it was so easy, but I didn't know anythink about OnKey! meny
Thanks