Works okay here. Can you do it to a new workbook?
--
Jim
"John Schneider" wrote in message
...
| Using Excel 2007, I created a macro in the
VB Editor. I then tried
assigning
| ctrl-h as the shortcut key: Developer Tab - Macros - Select newly
created
| macro - Options - h - OK - Cancel. When I go to a cell in the
| spreadsheet and hit ctrl-h, I get the Find And Replace dialog, which I
don't
| need for this spreadsheet. I then tried using other keys instead of "h".
If
| it is an unassinged key (i.e. "e"), I just get a beep. If it is a default
| key, I get the appropriate dialog. From what I've read, if you assign a
| shortcut key to one of the existing defaults (in this case "h"), it is
| supposed to override the default.
|
| No matter what key I try to use, nothing works. What am I missing here?
|
| Thanks