Excel for Mac - Runtime error 438 Doesn't support this property or method

[stephfr]

Hi,

I have a user who has a macro enabled workbook from an older version of Excel where at runtime, a menu was created. He has just migrated to the latest version of Office for Mac and it seems that the function is no longer supported. Do you have an idea of how I can create the menu items?

Here is part of the code:
With cmbControl
.Caption = "&Pascal" '
With .Controls.Add(Type:=msoControlButton)
.Caption = "Import Data Presse - Complet"
.OnAction = "'" & ActiveWorkbook.Name & "'!" & "ImportV2"
.FaceId = 1098
End With
With .Controls.Add(Type:=msoControlButton) '
.Caption = "Import Data Presse - Par Défaut"
.OnAction = "'" & ActiveWorkbook.Name & "'!" & "Importation"
.FaceId = 1098
End With

The macro fails on the line in red.
Thanks
Steph

 

[Jim Gordon]

Menus are no longer programmable. Instead, use the Ribbon. See this page by Ron De Bruin

 

[stephfr]

Great! Thanks a lot, Jim!