close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()