Seems to be working in Excel 2007, Will try on 2010 soon.
Thanks you BobUmlas!
I am running in Excel2010, and do not seem to find Application.MergenInstances. From what little I read:
Application.MergeInstances Property (Excel)
Excel 2013 additional instance functionality - Microsoft Community
...it appears to me that this Property was not added until Excel 2013, and is related to a change in the way Excel "normally" works (i.e. - what we are used to); that being, that apparently Excel makes it a bit harder to open a second (third, so on...) workbook in a new instance of the application
- if that makes sense.
That said, you said you ran this in Excel 2007?
The code does suppress a new instance of the spreadsheet, but,, When data in entered in the "first" instance and I try to open the workbook again I receive the warning:
"Window Estimatorv1.23.xlsm is already open, Reopening will cause any changes you made to be discarded. Do you want to reopen Window Estimatorv1.23.xlsm?"
At least my Techs will have to think twice. Is there a way to suppress the warning as well?
"Keep not thinking"
So... I hope I am not missing something, but exactly what do you mean by a "new instance of the spreadsheet"
At least for me, the "...is already open. Reopening will cause..." warning is issued if I try and open the same (unsaved) workbook in the same instance
of the application.
If I start a new
instance of the application, and try and open a workbook that I already have open in another instance of the application, then I get the warning, "... is locked for editing..." and the Open as Read-Only, Notify, or Cancel buttons/choices.
I hope I worded all that sensibly?