Here is some code to make spreadsheets open up in new instances...

Application.IgnoreRemoteRequests = True
'Open your file
Application.IgnoreRemoteRequests = False

Note that what this is doing is it is toggling the setting
Tools|Options - General -Ignore Other Applications
--
HTH...

Jim Thomlinson


"Gerry O" wrote:

I have an Excel workbook that uses userforms and save/close procedures
extensively to automate some processes. I need this workbook to always open
in a new instance of Excel. If the user already has a workbook open, opening
this file will open in the instance that is already open, which I don't want.
Is there any VBA code that will force this to happen? Much appreciated!
--
Thanks,

Gerry O.