Using Excel VBA I create a new Word document and paste some content.
I then want the user to review the resulting document and press
Continue for some additional processing. To do this, my Excel VBA
code displays a modal user form with a Continue button.

However, when the user form is displayed, the Excel spreadsheet is
displayed, instead of the Word document. It does not let me switch to
the Word document with the user form displayed. (I click on Word on
the Task Bar, but the display does not change.)

I am using Excel 2003 and Word 2003, running on WindowsXP.

Any ideas on how to get around this? Alan

the useform should be shown modeLESS


"Alan" wrote:

Using Excel VBA I create a new Word document and paste some content.
I then want the user to review the resulting document and press
Continue for some additional processing. To do this, my Excel VBA
code displays a modal user form with a Continue button.

However, when the user form is displayed, the Excel spreadsheet is
displayed, instead of the Word document. It does not let me switch to
the Word document with the user form displayed. (I click on Word on
the Task Bar, but the display does not change.)

I am using Excel 2003 and Word 2003, running on WindowsXP.

Any ideas on how to get around this? Alan