Button Click but not Shortcut Key

[robot]

I have a macro that involves opening an existing workbook as one of its
steps.

I assign both a button (on a worksheet) and a shortcut key to the macro.
When I click the button to run the macro, everything goes well. However,
when I use the shortcut key to run the macro, the macro terminates after
opening the workbook.

I use the shortcut key only when the worksheet containing the button is
active.

How to resolve the problem? Suggestions are most welcome! (I use Excel XP
and Win XP)

 

[Patrick Molloy]

could yuo show us your code? sometimes code breaks don't raise errors, the
macro just fails and exits