Tom Ogilvy wrote:
I will try to go with something like this:

for documentation and some explanation on Application Level Events,
you
might want to read Chip Pearson's site
http://www.cpearson.com/excel/appevent.htm

this reflects the method presented in VBA help, but see this simpler,
more
logical method suggested by KeepitCool and Further endorsed by Jamie
Collins
and which uses only the Thisworkbook class module (eliminating the
need to
instantiate the class and which keeps everything in one place)
<<snip

LOL! You could drop the further endorsement - it may put some people
off <g.

Jamie.

--