beware of parrying with Tom.
he has a mean riposte.

<G

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


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)

[KeepitCool, otherwise known as Jurgen Volkerink @ www.XLsupport.com ]