Rob,

" I have no idea what the code is for the keypad "+" sign"

This works for me...
Application.OnKey "{107}", "ColorCell"

Regards,
Jim Cone
San Francisco, USA


"RWN" wrote in message
...
Given I haven't received any response I assume that my original post (quoted below) was
not clear so I'll attempt to re-phrase the question.
How can I execute a macro when the user hits the "+" sign on the numeric keypad?
Original post;
I'd like call a macro (to re-position the cursor) when the "+" sign is pressed on the
numeric keypad.
After looking through the help and "playing around", the closest I can come is using an
"OnKey" statement but I can't get it to;
a) recognize the keypad "+"
b) call a macro, *even* when I give it a key that it can recognize.
ex, using the keyboard "+" sign.
I tried putting the Application.OnKey "{+}", "macroname" in a workbook open event and in
the Workbook module I put the "macroname" sub.
(The close event resets the key.)
What I get is "filename!macroname not found" (at least I know it's re-assigned the key!)
So I have two problems (not to mention my lack of understanding)
1st - I'm not structuring the logic correctly (it can't locate the macro) and,
2nd - I have no idea what the code is for the keypad "+" sign.
Direction?
Regards;
Rob