Excel 2016 Macintosh won't add custom menu using VBA

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.

July 11th, 2015 7:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics