Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
on press detection
is it possible to make a macro that detects when the enter button i
pressed? what im trying to to, automatically save and possibly exit the workboo when the enter button is pressed. this may sound odd but in th spreadsheet you only have to press enter at one point and thats befor you save and exit it. I need to save people time faffing around like muppets as they canno use excel correctly. Regards -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
on press detection
Hi,
I think i have seen this done, by using the ASCII vale for the Key and the worksheet update event, but i honestly can't remeber. However, i would strongly suggest not to use this method, and go for a button instead. No matter how bad you user are, an button, with save a close on it is very easy to use, also, i'm quite good on PC, and i press entre by mistake all the time! Anyway sorry can be of more help Good Luck Ross. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
key detection in user forms | Excel Discussion (Misc queries) | |||
Color detection | Excel Worksheet Functions | |||
Another last cell detection problem | Excel Programming | |||
VBA Detection of Workbook already Open | Excel Programming | |||
Detection of VBA code | Excel Programming |