>>As far as I know, it depends on the Excel version. At least in Excel 2002 >>(what I am using at the moment) it allows to work independently with
>> multiple instances. The problem is not for Excel only, but for some other
>> MS Office components too (see for example >>
http://www.mvps.org/access/general/gen0017.htm about UserControl option).
I have 2000, thought Client had 2002, but I'll gave to check. I'll have to play with the options, they use Excel a LOT and some of the automation routine can take while, so it's hard to stop them from using. I have to pleay with settings and try and error trap if the do close.
Many thanks for your input
Gary.