View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Schneider John Schneider is offline
external usenet poster
 
Posts: 9
Default Excel 2007 - Macro Shortcut Key Doesn't Work

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