Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I tried to adapt J.Walkenbach code to add a menu item on Workbook_open
but I get the following error on "HelpIndex = CommandBars(1).Controls ("Help").Index" Run-time Error '91' Object variable or with block variable not set Private Sub Workbook_Open() Dim HelpIndex As Integer Dim NewMenu As CommandBarPopup ' Get Index of Help menu HelpIndex = CommandBars(1).Controls("Help").Index ' Create the control Set NewMenu = CommandBars(1) _ .Controls.Add(Type:=msoControlPopup, Befo=HelpIndex, Temporary:=True) ' Add a caption NewMenu.Caption = "Fi<er" End Sub Help appreciated, J.P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA:programmatically invoking menu items from Excel Worksheet menu | Excel Programming | |||
Adding a Custom menu / sub menu | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Adding menu to the mouse right click pop-up menu | Excel Programming |