I have a number of keyboard shortcuts. Lets say lt;ctrlgt;lt;shiftgt;A runs code
in modA, lt;ctrlgt;lt;shiftgt;B runs code in modB, etc.
I'd prefer to collect all of this code in one module, say modShortcuts, but
still have the keyboard shortcuts work.
Is this possible?
TQ
Bri
How about 'calling' the procedure using the shortcut?
For example in the module containing all your shortcuts
sub macroname()
'Keyboard Shortcut: Ctrl Shift O
Call MacroYouWantToAssignToctrlshiftO
end sub
sub macroname()
'Keyboard Shortcut: Ctrl Shift X
Call MacroYouWantToAssignToctrlshiftXend subquot;Briquot; wrote:
gt; I have a number of keyboard shortcuts. Lets say lt;ctrlgt;lt;shiftgt;A runs code
gt; in modA, lt;ctrlgt;lt;shiftgt;B runs code in modB, etc.
gt;
gt; I'd prefer to collect all of this code in one module, say modShortcuts, but
gt; still have the keyboard shortcuts work.
gt;
gt; Is this possible?
gt;
gt; TQ
gt; Bri
gt;
gt;
gt;
- Aug 28 Tue 2007 20:39
keyboard shortcut question
close
全站熱搜
留言列表
發表留言