shortcut keys
You can assign Shift+Ctrl+letter manually the same way as Ctrl+letter. It's
simply the same but with the capital. You can also use
Application.MacroOptions, see help. (can also export the bas module to text
file, add the shortcut, and re-import).
If you want to include Alt + letter w/out any combination of Shift+Ctrl you
need to use the OnKey method, again see help for example. You will need to
run the OnKey code each time your macro project loads.
Regards,
Peter T
"cass calculator" wrote in message
...
How do you assign a macro to a shortcut key other than a combination
of ctrl that excel allows you to do from the toolsmacrooptions
screen? For example, what if i want to use Alt + 1, or Shift + Ctrl +
1, or Alt + Shift + 1?
Thanks!
J
|