keypress interception
 

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
--
Sergiovery (IT)

keypress interception
 

See OnKey Method in VBA Help
--
Gary''s Student - gsnu200752

keypress interception
 

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)

"Sergiovery" wrote in message
...
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
--
Sergiovery (IT)

keypress interception
 

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



"Gary''s Student" wrote:

See OnKey Method in VBA Help
--
Gary''s Student - gsnu200752