View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gandei Gandei is offline
external usenet poster
 
Posts: 5
Default 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



.