I have a situation where I am upgrading some old Excel files to Excel
2003.

One of the files ("Main") calls one of 6 other workbooks depending
upon the users selection, cycles through some data, creates a graph,
and shows a dialog box (from a dialog sheet on the "Main" workbook)
asking if the user wants to continue or various other options.

My problem is that with one of the 6 other workbooks ("400"), the
dialog box does not show up unless the user physically clicks the
Excel "400.xls" button on the taskbar (i.e. the dialog box comes up
but is hidden behind the current Excel window).

The Dialog sheet (written in Excel 97 or before) as well as all of
the VBA code is in the "Main" workbook and it's not handling the
400.xls differently than the other 5.


There are hundreds of lines of code, but here are the relevant
commands:

Set PlotOpt = DialogSheets("dlgOptPlot")
...
OK = PlotOpt.Show


Is there any property I can add before the .show method to make sure
the dialog box shows up?