2 Files Open In 2 Instances Of Excel

[Celtic_Avenger]

Hi.

Hope someone can help.


I have a spreadsheet that contains userforms as navigation tools fo
that specific spreadsheet.

If I open a windows browser and try to load another Excel file whils
one of these Userforms is active, it does open the file, but behind th
userform.

This also then causes problems with the navigation of the buttons o
the userform, as the buttons tend to point t
ActiveWorkbook.Sheets........ etc.

Is there a way to set Excel to open all new files double clicked on i
the Windows browser, in completely separate instance of Excel? So tha
they would run separately and not affect each other.

In other words, this would then give 2 or more Excel programs showin
in the Windows Taskbar, and allow users to move between them using th
taskbar icons.

I have seen this happen on other peoples computers, but am not sure ho
it is done.

Thanks for any help you can give me.

Celtic_Avenger
:confused

 

[Dave Peterson]

First, I don't like to run multiple instances of excel. It makes it more
difficult to share information between workbooks.

But you could try:

Tools|Options|General|Ignore other applications (check it)

Remember what you did so you can turn it off <vbg>.