How do we assign a keyboard combination to a macro?
How do we assign a keyboard combination to a macro?
Call the macros from the worksheet side with Alt+F8, select a macro, and choose Options.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Press ALT-F8 select macro and then Select Options.
This from recording daffodil's and bakerman2's response:
Sub SetKey() 'If key is Uppercase use Ctrl+Shift+Key but always use Ctrl Application.MacroOptions Macro:="Zanshin", ShortcutKey:="Z" End Sub
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks