beforerightclick and selection change issue
 

I have a report where I use the selection change worksheet event to display a
form1. I want to use the beforerightclick event to display another form,
form2 and not display the form from the selection change. I have a
workaround but form1 quickly displays and then unloads in a flicker. I don't
want to see this flicker.

Here is my code:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
'unload form1 which is displayed on the selection change event
Unload frmAcctDrillDown
Cancel = True
'load form2
Load frmNotes
frmNotes.Show


End Sub