Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Onkey vs Macro Short cut key
Is there a benefit to using the macro short cut key in macro options vs coding a key combo using Onkey? Thanks Richard -- rgarber50 ------------------------------------------------------------------------ rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350 View this thread: http://www.excelforum.com/showthread...hreadid=385952 |
#2
|
|||
|
|||
I don't think there is a huge difference but with the macro options approach
the shortcut is almost always there. For instance it takes a macro to run to set the Onkeys but not for macro options. And to extend that, macro options is there even if Shift is held down when the workbook is opened to keep auto macros from running. And another difference is that if the workbook is closed that has the macro options macro the shortcut is automatically terminated. But with Onkeys the shortcut still exists and Excel will still look for the macro. -- Jim "rgarber50" wrote in message ... Is there a benefit to using the macro short cut key in macro options vs coding a key combo using Onkey? Thanks Richard -- rgarber50 ------------------------------------------------------------------------ rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350 View this thread: http://www.excelforum.com/showthread...hreadid=385952 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save original data after macro is run again | New Users to Excel | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |