How to identify method for an assigned shortcut?

[chandansify]

Hi,

Is there a way to findout the method name via it's shortcut key?

Details:
e.g. A shortcut key Ctrl+Alt+F9 is assigned to an unknown function.

I want to change the functionality but I really don't know the target code? Is there a way in Excel VBA to find out the target method name using it's shortcut keys?

Thanks in advance.

CB

[Aflatoon]

If you mean built-in shortcuts, then you can't change their code functionality, you can only point the shortcut key combination at another routine of your own.

[mdmackillop]

Try using the macro recorder. For Ctrl+Alt+F9 I get
Sub Macro1()
'
' Macro1 Macro
'

'
Application.CalculateFull
End Sub

[chandansify]

If you mean built-in shortcuts, then you can't change their code functionality, you can only point the shortcut key combination at another routine of your own.

Nope, I mean shortcuts pointing to custom method.

[chandansify]

Try using the macro recorder. For Ctrl+Alt+F9 I get
Sub Macro1()
'
' Macro1 Macro
'

'
Application.CalculateFull
End Sub


This was just an example.

e.g. What if someone has assigned a shortcut to ABC method using Application.OnKey and I am not aware of it.

Now, how to findout that ABC method using that shortcut via VBA?

[mdmackillop]

Did you try it? What was the result?

[chandansify]

Did you try it? What was the result?

Hi,

This doesn't help in my case as I have already mentioned that I have to do this via VBA and not by recording a macro.

Thanks.