keyboard shortcut question

B

Bri

I have a number of keyboard shortcuts. Lets say <ctrl><shift>A runs code
in modA, <ctrl><shift>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
 
J

jennifer

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 sub
 
Top