Mandy
07-02-2007, 02:33 AM
Hi:hi:
i have a problem. first look the following code.
Private Sub Workbook_Open()
Call Keyworks
End Sub
Sub Keyworks()
Application.OnKey "{down}", "message"
End Sub
Sub message()
MsgBox "Can Some one Help Me!"
End Sub
according to this code when this workbook open next time, and if i press down key it should show the message(can some one help me).
but i am getting error message that is given below.
The Macro "c:\Documents and Settings\My Docuements\VBA.xls'!message' cannot be found.
what this indicates.
can any one tell me how i can show the message by pressing the down key.
Thanks
i have a problem. first look the following code.
Private Sub Workbook_Open()
Call Keyworks
End Sub
Sub Keyworks()
Application.OnKey "{down}", "message"
End Sub
Sub message()
MsgBox "Can Some one Help Me!"
End Sub
according to this code when this workbook open next time, and if i press down key it should show the message(can some one help me).
but i am getting error message that is given below.
The Macro "c:\Documents and Settings\My Docuements\VBA.xls'!message' cannot be found.
what this indicates.
can any one tell me how i can show the message by pressing the down key.
Thanks