on press detection

[Fraggs]

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

 

[ross]

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.