sheet event procedure

[R.VENKATARAMAN]

I have prepared three userforms. sheet2 event procedure is beforerightclick
and it opens userform1. Each userform has commandbutton to open the next
one and hide the previous one. after all the userforms are operated the code
is made to comeback to sheet2. But right click of sheet2 brings in the
quick menu initially and it stays even after the code makes it to comeback
to sheet2. I have to hit <esc> or click some other cell to close the quick
menu . Is there any way to close the quick menu automatically. This may be
a simple query for an expert but for me the way out escapes me;

my last code statment is (this is a commandbutton)

Private Sub go_back_to_sheet2_Click()
userform3.Hide
Worksheets("sheet2").Activate
End Sub

mine is excel2000 windows98
thanks and regards

 

[Patrick Molloy]

In the sheet's event handler, make sure that you set
Cancel = True ...this prevents the menu popup from opening

eg

Private Sub Worksheet_BeforeRightClick(ByVal Target As
Range, Cancel As Boolean)
Cancel = True
UserForm1.Show
End Sub

Patrick Molloy
Microsoft Excel MVP

 

[R.VENKATARAMAN]

thank you Mr. Patrick Molly. That means I have to carefully study the
arguments.