Brilliant! Just what I needed.

Many thanks Tom, you have an enviable knowledge of VBA

--Kiloran

"Tom Ogilvy" wrote in message
...
In tools=Options in the general tab, select Ignore Other applications.

Application.IgnoreRemoteRequests = True

in VBA

--
Regards,
Tom Ogilvy

"Kiloran" wrote in message
...
While a long macro is running in Excel 2002 VBA, and a user opens
another
Excel document on the PC, or opens an excel attachment in an email, I
would
like to prevent these Excel documents opening in the same
session/instance
as the one in which the macro is running, and start a new instance of
Excel
if necessary.

Is there any way in VBA to control this?

--Kiloran