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

  • Thread starter Thread starter Malfane
  • Start date Start date
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,
 
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.
 
Back
Top