I've made a bunch of shortcuts to format numbers, as follows. All of them work, except the Ctrl+Shift+5
, Ctrl+Shift+6
and Ctrl+Shift+7
shortcuts. The problem seems to be with the shortcut keys, because if I try to use another key (Ctrl+Shift 1
, 2
, 3
), with the same function, then it works.
Application.OnKey "^+v", "pasteValues"
Application.OnKey "^+1", "'formatAs""" & "number" & """'"
Application.OnKey "^+2", "'formatAs""" & "number2" & """'"
Application.OnKey "^+3", "'formatAs""" & "date" & """'"
Application.OnKey "^+5", "'formatAs""" & "percentage" & """'"
Application.OnKey "^+6", "'formatAs""" & "percentage2" & """'"
Application.OnKey "^+7", "'formatAs""" & "general" & """'"
I've also re-ran the function that sets the keyboard shortcuts, in case any add-in or something was overriding my shortcuts.
Any ideas?