In ThisWorkBook of Personal.xls

Private Sub Workbook_Open()
' Created by Patricia Shannon 4/5/2006
' Sets F3 to exit Excel

Application.OnKey "{F3}", "ExitThisPgm" ' run a macro
Application.OnKey "{F6}", "CloseOtherApplication" 'execute key strokes
End Sub
=============================================
In a regular module of Personal.xls

Public Sub ExitThisPgm()
' Created by Patricia Shannon 4/5/2006
' this runs a macro

Debug.Print "Sub ExitThisPgm"
Application.Quit

End Sub

Public Sub CloseOtherApplication()
' Created by Patricia Shannon 4/12/2006
' Go to most recent other application and close it

''Debug.Print "Sub CloseOtherApplication"
SendKeys "%{TAB}{F3}"
=================================================

"furia" wrote:

How do I Customize keyboard shortcuts under Excel?

Under Tools menu, Customize submenu, Commands option, there is no
"Keyboard..." button as there is for Microsoft Word:
http://office.microsoft.com/en-us/as...867041033.aspx

Microsoft Excel for Mac also has this option:
http://www.microsoft.com/mac/product...mKeyboards.xml

This limitation also exists on all other Office Products: (PowerPoint,
Outlook, Project, Access)!

Is it because only Word has the normal.dot template? But, what about Excel
for Mac?

Thanks.