| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always Open in New Instance
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open a new instance of EXCEL and .xls file | Excel Worksheet Functions | |||
| How to open a new instance of Word and its .doc file | Excel Worksheet Functions | |||
| open excel in a separate instance | Excel Discussion (Misc queries) | |||
| Open files within one instance of Excel | Setting up and Configuration of Excel | |||
| how to re-set excel2000 to open a second instance in a separate wi | Excel Discussion (Misc queries) | |||
Threaded Mode
