To always start on a new instance, use this free utility:
....and to keep an instance temporally in exclusive mode, use this two events
Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
"jvaughn75" wrote in message
I have a user that needs to open 2 spreadsheets in 2 different Excel
She had the "Ignore other applications that use Dymanic Data Exchange
checked, allowing for multiple instances of Excell, but this function did
allow her to double click a file to open in Excel. She would have to open
Excel, and open the file that way. Unchecking this box allows the files
be opened by double clicking, but takes away the ability to open multiple
instances of Excel.
We, as a company, are migrating from Office 2003 to Office 2007 and the
states she was able to do this in Excel 2003 with no problems. Did this
functionality change in Excel 2007, or are there more settings to check?
Thanks in advance for the help.