VB Forms Behave Differently in Excel 2003 and Excel 2013

See more:

VB

MS-Excel

forms

Hi
I've an Excel 2003 Project that runs OK in Excel 2013 with one problem;

The project uses a Modeless Form

Using 2003, this Form appears on top of the Excel Workbook Window, regardless of how many Workbooks are Open, or which Workbook is selected

Using 2013, the Form is only visible when the Parent Workbook is Selected

I'd like to find the easiest way to duplicate the Form's original behaviour

This behaviour seems to be associated with the fact that each Workbook is now a separate Windows Process, whereas in 2003 all the Open Workbooks shared one Process

I've unsuccessfully played around trying to re-parent the Form (using the SetParent API) during the Application_WorkbookActivate Event, bt I'm wondering if anyone can help me out with a simpler solution

Thanks in advance