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;

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

software

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