Alternative:
instead of dumping a lot of code in workbooks
that are essentially supposed to contain data

my approach would (probably) be to create an addin with
an application level event handler.


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


wrote :

Hi guys,

Thanks for the prompt replies.
I guess I can stop worrying about it now.

Unless of course you'd like to point me in the right direction to get
round this.

Cheers,
JF.