Macro shortcut key

  • Thread starter Thread starter Gandei
  • Start date Start date
G

Gandei

Hi Experts

To run a macro without mouse clicks I assigned a shortcut
key to it (Ctrl+Shift+M). When I tried it, the macro was
called up ok, but stops after opening a file!!
Strangly, the full macro ran fine when invoked with mouse
clicks (Tools->Macro->Macros and Run). What could be the
cause for this behaviour?

Microsoft Excel 2002 (version: 10.2614.2625) on Win2000
Pro.
Please help.

Thanks
Gandei
Surrey, UK
 
having the shift in the shortcut combination causes macros to be disabled.
You need to use a shortcut that does not include a shift.
 
Back
Top