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

--
Message posted from http://www.ExcelForum.com

Hi
AFAIK not possible with the build-in shortcut assignment

--
Regards
Frank Kabel
Frankfurt, Germany


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


---
Message posted from http://www.ExcelForum.com/

than

--
Message posted from http://www.ExcelForum.com

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

In article ,
shasta wrote:

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