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