Get vb windows form to open in front of Excel sheet that is open.

[=?Utf-8?B?QXNobGV5VA==?=]

Inside :

Private Sub _xlApp_Workbook BeforeClose(ByR ef Cancel As Boolean) Handles
_xlApp.Workbook BeforeClose

I have

Try
Dim QuoteActivity As New QuoteSheetActiv ityForm()
QuoteActivity.B ringToFront()
QuoteActivity.S howDialog()
Catch
End Try

BUT is always shows up behind the Excel sheet. How can I either have this
form open right AFTER the excel closes or when it opens as a dialog be in
front of the excel sheet. The excel sheet is opened in front of the main
form of my windows application.

Thanks for the help!

[cfps.Christian]

Re: Get vb windows form to open in front of Excel sheet that is open.

I think you're looking at this from the wrong angle. Go into the
QuoteSheetActiv ityForm and set its TopMost property on then off, or I
believe there is a TopLevel property too.

You could also try calling me.BringToFront () in the Form_Load event of
the QuoteSheetActiv ityForm.