Hi,

Is there a way to assign aMacro or VB code to a F-key such as F12,

Thanks
--
WayneR

If you assign a macro to a Function key, it takes away the built-in program
for that key, even when you close the workbook for your macro. You can
assign a macro to any key for a letter of the alphabet and most symbols as
short cut keys without changing any of the built-in functionality of the F
keys. It is just as easy to do and to use.

"WayneR" wrote:

Hi,

Is there a way to assign aMacro or VB code to a F-key such as F12,

Thanks
--
WayneR

Look at application.onkey.

Option Explicit
Sub RunMyF6Macro()
Application.OnKey "{f6}", "RunMyF6"
End Sub

Sub RunMyF6()
MsgBox "hi from F6"
End Sub

'And this would toggle it back to normal.
Sub PutItBack()
Application.OnKey "{f6}"
End Sub



WayneR wrote:

Hi,

Is there a way to assign aMacro or VB code to a F-key such as F12,

Thanks
--
WayneR

--

Dave Peterson