View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerry O Gerry O is offline
external usenet poster
 
Posts: 18
Default Always Open in New Instance

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.