View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sandro[_2_] Sandro[_2_] is offline
external usenet poster
 
Posts: 2
Default Displaying A custom menu as a popup menu

then maybe you can do it this way

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
Cancel As Boolean)

Cancel = True
YourToolBar.show

End Sub

On Sep 21, 10:58 pm, diddy_david
wrote:
Thanks but I have already created a toolbar manually, how can this become a
popup menu. In access you change the menu type manually to popup and the
assign the name of the toolbar in a form property, I do't want to create a
new tool bar from scratch.