shortcut macro keys

[shasta]

when u create a macro it gives u an option to have a shortcut key...i
it possible to have the return key as a shortcut

 

[Frank Kabel]

Hi
AFAIK not possible with the build-in shortcut assignment

 

[shasta]

than

 

[JE McGimpsey]

One way:

Public Sub test()
Application.OnKey "{RETURN}", "MyReturnMacro"
End Sub

Public Sub MyReturnMacro()
MsgBox "You pressed Return"
End Sub

You can put the Application.OnKey call in your Personal.xls
Workbook_Open sub