Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I assign a shortcut key (alt letter) to the format painter
The topics on the excel help cover using existing shortcut keys, but the
instructions are not clear on whether or not I can assign a new shortcut, for example ALT + SHIFT + f, to select the paintbrush for formating. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I assign a shortcut key (alt letter) to the format painter
put this in the Workbook_Open event of your personal.xls:
Private Sub Workbook_Open() Application.OnKey "%^f", "fmt" End Sub and this in a standard module: Sub fmt() CommandBars("Standard").FindControl(ID:=108).Execu te End Sub Unfortunatley, you're going to need to include the ctrl key (my key sequence is alt/ctrl/f). Bob Umlas Excel MVP "Mike Blake" wrote in message ... The topics on the excel help cover using existing shortcut keys, but the instructions are not clear on whether or not I can assign a new shortcut, for example ALT + SHIFT + f, to select the paintbrush for formating. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I assign a shortcut key (alt letter) to the format painter
Bob,
This works great for Excel, but is there a way to do this across all ms applications (word, PP, etc.) Thanks! "Bob Umlas" wrote: put this in the Workbook_Open event of your personal.xls: Private Sub Workbook_Open() Application.OnKey "%^f", "fmt" End Sub and this in a standard module: Sub fmt() CommandBars("Standard").FindControl(ID:=108).Execu te End Sub Unfortunatley, you're going to need to include the ctrl key (my key sequence is alt/ctrl/f). Bob Umlas Excel MVP "Mike Blake" wrote in message ... The topics on the excel help cover using existing shortcut keys, but the instructions are not clear on whether or not I can assign a new shortcut, for example ALT + SHIFT + f, to select the paintbrush for formating. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I assign keyboard shortcut for Grouping? | Excel Discussion (Misc queries) | |||
Disable format painter in excel 2003 | New Users to Excel | |||
Shortcut to format painter | Excel Discussion (Misc queries) | |||
Format Painter button problem | Excel Discussion (Misc queries) | |||
Letter format | Excel Discussion (Misc queries) |