Completely disable ctrl key?

Originally Posted by 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.

Please Login or Register  to view this content.

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?