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.
Get vb windows form to open in front of Excel sheet that is open.
Collapse
This topic is closed.
X
X
-
Guest replied -
Get vb windows form to open in front of Excel sheet that is open.
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!
Tags: None
Leave a comment: