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 |
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 |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com