Previously I had an Excel 97 file that would open a modal form (main menu), then after user interaction, open another modal form (sub menu) over the top of the original form. This would work fine in Excel 97.
Now in Excel 2003 the sub menu form randomly decides if it will show over the top of the main menu or behind it. Obviously when behind it causes a problem.
How can I gaurantee the newly opened form is on top everytime?
I've tried setting focus without much luck. I want to avoid hiding the main menu before the sub menu opens. Any ideas ?
Now in Excel 2003 the sub menu form randomly decides if it will show over the top of the main menu or behind it. Obviously when behind it causes a problem.
How can I gaurantee the newly opened form is on top everytime?
I've tried setting focus without much luck. I want to avoid hiding the main menu before the sub menu opens. Any ideas ?
