customize keyboard

[john.e.palmer]

I would like to customize my keyboard so that F2, as well as control
+U, will = "edit cell". I can't find the "edit cell" command under
the customize keyboard dialog box. What's the best way to do this?

I'm certainly willing to create a macro, but I also can't figure out
how to reset the shortcut keys for a macro. How do I change the
shortcut keys for a macro in excel?

Thanks.

 

[CyberTaz]

Perhaps this will save you some time:

http://mcgimpsey.com/macoffice/excel/f2.html

 

[john.e.palmer]

Perhaps this will save you some time:

http://mcgimpsey.com/macoffice/excel/f2.html

Thanks for the link.
Re-defining shortcut keys?
thanks.

 

[CyberTaz]

Thanks for the link.

Re-defining shortcut keys?
thanks.

Sorry - must have overlooked that Try Tools> Macro> Macros, select the
macro by name & click Options... at least I seem to remember it working that
way on the Mac. Unfortunately I'm not where I can check at the moment.

 

[john.e.palmer]

Sorry - must have overlooked that Try Tools> Macro> Macros, select the
macro by name & click Options... at least I seem to remember it working that
way on the Mac. Unfortunately I'm not where I can check at the moment.

I found where to change, but the change is limited pretty much to
option+command sequences. Is there a way to change the shortcut to
have a control+option+command+(letter) sequence?
Thanks.

 

[JE McGimpsey]

I found where to change, but the change is limited pretty much to
option+command sequences. Is there a way to change the shortcut to
have a control+option+command+(letter) sequence?

One way:

Put this in the ThisWorkbook code module of the workbook containing the
macro:

Private Sub Workbook_Open()
Application.OnKey "^%*a", "MyMacro"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^%*a"
End Sub

Private Sub Workbook_Activate()
Application.OnKey "^%*a", "MyMacro"
End Sub

Private Sub Workbook_Deactivate()
Application.OnKey "^%*a"
End Sub

(The last two only if you don't want the macro to run in other workbooks)

 

[john.e.palmer]

One way:

Put this in the ThisWorkbook code module of the workbook containing the
macro:

Private Sub Workbook_Open()
Application.OnKey "^%*a", "MyMacro"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^%*a"
End Sub

Private Sub Workbook_Activate()
Application.OnKey "^%*a", "MyMacro"
End Sub

Private Sub Workbook_Deactivate()
Application.OnKey "^%*a"
End Sub

(The last two only if you don't want the macro to run in other workbooks)

Worked.
Thanks!