Completely disable ctrl key?

[mcgrad]

Is there a way to completely disable the Ctrl key?
I understand i can use code such as ".OnKey "^c" to disable Ctrl+C. But what I'm after is completely disabling the ctrl, without having to define every key combination.

Basically, I'm trying to prevent users from highlighting a range of cells and using ctrl+Enter to fill the highlighted range.

.OnKey "+{Enter}", "Warning"

Will trigger my msgbox box warning sub, but still allows the user to fill the highlighted range.

Can anyone help me make my code more robust?

[davesexcel]

Is there a way to completely disable the Ctrl key?
I understand i can use code such as ".OnKey "^c" to disable Ctrl+C. But what I'm after is completely disabling the ctrl, without having to define every key combination.

Basically, I'm trying to prevent users from highlighting a range of cells and using ctrl+Enter to fill the highlighted range.

.OnKey "+{Enter}", "Warning"

Will trigger my msgbox box warning sub, but still allows the user to fill the highlighted range.

Can anyone help me make my code more robust?

Hi mcgrad,
Do you want the user not to be able to edit a range of cells?
Have you considered protecting the sheet?