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