Trapping key pressed in a worksheet
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 |
Trapping key pressed in a worksheet
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. -- Vasant "John" wrote in message om... 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 |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com