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

/ keyboard key doesn't work in Excel 2007 1
Excel 2007 - Macro Shortcut Key Doesn't Work 3
Cut and "insert cut cells" in Excel 2007 doesn't work. 11
Word 2007 Print Key Assignments does not show Macro Name 3
difference in macro recording from 2003 to 2007 excel killing me. 2
Macro Doesn't Run With Command Button, But Does Run With F8 Key 3
shortcut key for language selection doesnt work only in Excel 0
Editing macro does not work 1

Top