Home |
Search |
Today's Posts |
#1
|
|||
|
|||
KeyBindings like Word.
Hello,
I would like to use KeyBindings in Excel like we have in Word. My purpose is creating a shortcut (e.g Ctrl+J) for a command in Excel (e.g FormatCondition). In other word, each time I will press Ctrl+J i will run the FormatCondition dialog will appear. Is there any way to do it ? With thanks, Moshe |
#2
|
|||
|
|||
I believe you need to create a macro that shows that dialog, and attach your
shortcut key to the macro. The macro needs just a single line Sub ShowCFDialog() Application.Dialogs(xlDialogConditionalFormatting) .Show End Sub Then in Tools/Macro/Macros, select this macro, click the Options button to assign the shortcut key. On Wed, 9 Feb 2005 00:49:41 -0800, "Moshe" wrote: Hello, I would like to use KeyBindings in Excel like we have in Word. My purpose is creating a shortcut (e.g Ctrl+J) for a command in Excel (e.g FormatCondition). In other word, each time I will press Ctrl+J i will run the FormatCondition dialog will appear. Is there any way to do it ? With thanks, Moshe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Hyperlink to a word document | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel | |||
S.O.S :importing excell data into word | Excel Discussion (Misc queries) |