Button Click but not Shortcut Key

  • Thread starter Thread starter robot
  • Start date Start date
R

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)
 
could yuo show us your code? sometimes code breaks don't raise errors, the
macro just fails and exits
 
Back
Top