Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
customize keyboard shortcuts
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
customize keyboard shortcuts
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
customize keyboard shortcuts
Thanks Patricia,
however I do not want to create marcos (or assign keyboard shourtcut to existing macros), but, instead, I want to reassing keyboard shortcut to existing Excel features (such as Save, Bold, Underline, etc.)! The problem is that I'm used to English shortcuts and sometimes I have to use Brazilian Office (not the multilanguage version), which has unfortunatelly different shortcuts! I could change all shortuct for Word, but not for Excel (or PowerPoint, Outlook, Access, etc.) Did you take a look at the links below? "Patricia Shannon" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
customizing keyboard shortcuts | Excel Discussion (Misc queries) | |||
in frontpage we should customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
applying borders to cells using keyboard shortcuts in excel | Excel Discussion (Misc queries) | |||
How do I display all assigned keyboard shortcuts? | New Users to Excel |