vba - Application.OnKey Ctrl Shift 0 -

i'm trying tie macro key combinations in excel 2010 (v14.0).

in thisworkbook code i've:

option explicit  private sub workbook_open()     application.onkey "^+1", "foo"     application.onkey "^+0", "bar" end sub

in module1 code:

option explicit  sub foo()     msgbox "hello" end sub  sub bar()     msgbox "world" end sub

when press ctrl+shift+1 excel says "hello". when press ctrl+shift+0 excel not says "world".

i cannot application.onkey work ^+0 macro. there way this? why doesn't code above work?

in addition jeeped's answer:

alt-h-o-u-l unhides columns in excel 2016. c hides them.

and substitute following in jeeped's code:

commandbars("column").controls("unhide").execute.

don't know it's improvement on entirecolumn.hidden = false, heck.

Ben