Button Click but not Shortcut Key
 

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)

Button Click but not Shortcut Key
 

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

"robot" wrote:

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)