Form to always appear in the front of the worksheet (using VSTO)

Hi Experts, I am writing a VSTO (Excel) application using VB.NET. I have an Excel worksheet as the main interface. When I double-click on the cells, I want to call up my Windows Form - frmMain. I have able to call up the form but the form always goes behind the worksheet despite of me typing frmMain.BringToFront().

In VB6, the instruction frmMain.Show vbModeless, Me will do the job. However in VB.NET, the show method accepts no argument. Please advice me on how to make this frmMain always appear in front of the Excel worksheet.

TIA.
bpyeoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RonaldBiemansConnect With a Mentor Commented:
you could cancel that action in the mousedown event of the form (don't forget to set the keypreview property to true in your form)

Private Sub Form5_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown
        If e.Alt = True and e.KeyCode = Keys.F4 Then
                e.Handled = True
        End If
    End Sub
0
 
Mike TomlinsonConnect With a Mentor Middle School Assistant TeacherCommented:
Try setting the TopMost property of frmMain to True.

Idle_Mind
0
 
bpyeoAuthor Commented:
Hi Idle_Mind, thanks for your advice. Now how could I ensure that the user will not pressed ALT-F4 to close this form? I have made the form not to show up in the taskbar and the form does not have any border. However the user can still close the form by pressing ALT-F4. Hope to hear from your expertise advice.

TIA.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.