Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 - Macro Shortcut Key Doesn't Work
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 - Macro Shortcut Key Doesn't Work
Jim,
Thanks for the response. Just tried created a new workbook from scratch, and I'm having the same problem. I've looked through all the settings I can think of, but still can't get a simple shortcut to work. Any other ideas? "Jim Rech" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Shortcut do not work | Excel Discussion (Misc queries) | |||
Ctrl and + on keyboard shortcut doesn't work in 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 shortcut Ctrl and + doesn't work | Excel Discussion (Misc queries) | |||
NEW: Macro KB shortcut doesn't work (otherwise Ok) | Excel Programming | |||
macro shortcut keys don't work | Excel Discussion (Misc queries) |