Trapping key pressed in a worksheet

  • Thread starter Thread starter John
  • Start date Start date
J

John

How can one trap when a key is pressed in a particular worksheet? I
would like to stop a user from entering data in a particular worksheet
but do not want to protect the worksheet because I don't like the ugly
message that pops up when a worksheet is protected. Or is there way I
can get rid of the ugly message?

Thank you
John
 
Unfortunately there is no KeyPress event for a worksheet.

Possibly the best way to do what you want would be to set the
EnableSelection property of the worksheet to xlUnlockedCells or
xlNoSelection.
 
Back
Top