L
Lynn
Hi anyone,
I create a menu for an excel workbook using this:
Sub CreateMenu()
' is automatically executed from an Aut
pen macro or a
Workbook_Open eventmacro
Dim cbMenu As CommandBarControl, cbSubMenu As
CommandBarControl
Set cbMenu = Application.CommandBars(1).Controls.Add
(msoControlPopup,before:=11 , , , True)
With cbMenu
.Caption = "&My menu"
.Tag = "MyTag"
.BeginGroup = False
End With
End Sub
"My menu" is showing fine, until someone clicks on a chart
in the worksheet, then My menu is no longer showing, util
the cursor is clicked somewhere else other than the chart
area, then My menu is showing.
Any idea to help keep "My menu" shows all the time until
the workbook is closed?
Thanks!
I create a menu for an excel workbook using this:
Sub CreateMenu()
' is automatically executed from an Aut
pen macro or aWorkbook_Open eventmacro
Dim cbMenu As CommandBarControl, cbSubMenu As
CommandBarControl
Set cbMenu = Application.CommandBars(1).Controls.Add
(msoControlPopup,before:=11 , , , True)
With cbMenu
.Caption = "&My menu"
.Tag = "MyTag"
.BeginGroup = False
End With
End Sub
"My menu" is showing fine, until someone clicks on a chart
in the worksheet, then My menu is no longer showing, util
the cursor is clicked somewhere else other than the chart
area, then My menu is showing.
Any idea to help keep "My menu" shows all the time until
the workbook is closed?
Thanks!