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
|