We make an addin that adds a menu to Excel. Excel 2016 Mac will not add the menu.
Works fine in XL97-2003, XL2011 (Mac).
Ribbon menu works fine in XL2007-2013.
But neither will add a menu to XL2016 Mac.
Menu Code:
With Application.CommandBars("Worksheet Menu Bar")
QIVer = "&QI Macros 2015"
iHelpMenu = .Controls.Count
With .Controls
With .Add(msoControlPopup, _
Before:=iHelpMenu, _
Temporary:=True)
'With .Add(msoControlPopup)
.Caption = "&QI Macros 2015"
With .Controls
With .Add(msoControlButton)
.Caption = QICommon.MsgText(267) '"Control Chart Wizard"
.FaceId = 435 ' Chart Wizard
.OnAction = "CCWizard.Run_CCWizard"
.BeginGroup = True
End With
etc.