Forgotten VBA keyboard shortcut

Question

I assigned my macro to a keyboard shortcut in Excel-VBA. It was a long time ago and I forgot to which key. How can I see it?

Check this thread: http://stackoverflow.com/questions/16862306/excel-vba-to-list-key-bindings-onkey — Robin Mackenzie, Oct 05 '16 at 10:34

score 4 · Answer 1 · edited Feb 28 '18 at 14:45

4

Bring up the Macro dialog box (Alt+F8 or Macros on the View ribbon).

Select your macro.

Click the Options button.

edited Feb 28 '18 at 14:45

answered Oct 05 '16 at 10:27

Thanks, that was the first place I looked at. It's empty but I'm sure that I could launch it from the keyboard. – z32a7ul Oct 05 '16 at 11:03

score 0 · Accepted Answer · answered Oct 09 '16 at 08:33

0

Well, I found it.

Private Sub Workbook_Open()
    Application.OnKey "{F12}", "MyMacro"
End Sub

answered Oct 09 '16 at 08:33

z32a7ul

2 Answers2