Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating keyboard shortcuts
The format painter does a copy, paste special formats, so you can use the
standard copy short cut of <Ctrl + C and then record a macro the does an EDIT/PASTE SPECIAL/FORMATS and assign the macro to a shortcut key. Or you can place the following line of code in a module and assign it the short cut key: Sub PasteFormats() Selection.PasteSpecial Paste:=xlPasteFormats, _ Operation:=xlNone, SkipBlanks:=False, _ Transpose:=False End Sub -- Kevin Backmann "jmcclain" wrote: Is there a way to create a custom keyboard shortcut? I would like to prevent having to use the mouse to select the formatting paintbrush. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcuts | Excel Discussion (Misc queries) | |||
Keyboard shortcuts | Excel Discussion (Misc queries) | |||
customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
Keyboard shortcuts | Excel Discussion (Misc queries) | |||
KEYBOARD SHORTCUTS | Excel Discussion (Misc queries) |