Excel 2007 Macro shortcut key doesn't work but menu selection does

M

Malfane

I have a very short set of Macro's one of my users has recorded. All of them
worked at first but now one of them will not function via the shortcut key.
It will function if you select and run it by using alt-f8, clicking on it
then run. Out of curiosity I reinstalled office, same problem. Then I even
gave him a new PC to play with. He recorded the macros and they ran fine for
many days then the same problem recurred.

Any thoughts?

Thanks,
 
D

Dave Peterson

Does the macro open another workbook?
Does the shortcut key include the shift key?
Does the macro actually start, but stop right after it opens the other file?

If yes to all, try removing the shift key from the shortcut key combination.

If no to any, then you may want to explain how it fails and even post the code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - Macro Shortcut Key Doesn't Work 3
Word 2007 Print Key Assignments does not show Macro Name 3
Macro doesn't execute fully using shortcut 6
Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work 7
difference in macro recording from 2003 to 2007 excel killing me. 2
Shortcut key to open program doesn't work 3
Windows XP Shortcut Key Combinations 0
Macro Doesn't Run With Command Button, But Does Run With F8 Key 3

Top