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)