View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default Pressing Enter Key

I was hoping that with the combination of ThisWorkbook module and your
getstarted page (if the OP had never seen macros) would be sufficient.

But I agree that your event page should have been included. In fact, here's my
standard cut and paste for events:

There are lots of these worksheet/workbook events that you can tie into. Here's
a couple of links that you may want to bookmark:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

======
But I got lazy....

David McRitchie wrote:

In this case my event.htm page would be better than my getstarted.htm page.

Specifically for workbook macros which get installed in
ThisWorkbook the shortcut would be:
RightClick on the Excel logo to left of file menu, then use "View Code"

To get to know event macros better see
http://www.mvps.org/dmcritchie/excel/event.htm
and workbook event macros material begin at
http://www.mvps.org/dmcritchie/excel....htm#blueboxWB
---
HTH,
David McRitchie
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Dave Peterson" wrote in message
Both of these events go behind the ThisWorkbook module.
[clipped...]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--

Dave Peterson