Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro shortcut help | Excel Worksheet Functions | |||
Shortcut to a Macro | Excel Discussion (Misc queries) | |||
Shortcut key to VB macro | Excel Discussion (Misc queries) | |||
Macro Shortcut Key | Excel Discussion (Misc queries) | |||
Macro shortcut from XLA | Excel Programming |