Onkey vs Macro Short cut key

R

rgarber50

Is there a benefit to using the macro short cut key in macro options vs
coding a key combo using Onkey?

Thanks

Richard
 
J

Jim Rech

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top