Macro shortcut key
 

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

Macro shortcut key
 

having the shift in the shortcut combination causes macros to be disabled.
You need to use a shortcut that does not include a shift.

--
Regards,
Tom Ogilvy

"Gandei" wrote in message
...
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

Macro shortcut key
 

Thanks Tom.
Only today I found out about this newsgroup. Very exciting
and useful.

G

-----Original Message-----
having the shift in the shortcut combination causes
macros to be disabled.
You need to use a shortcut that does not include a shift.

--
Regards,
Tom Ogilvy

"Gandei" wrote in message
...
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


.