Importing Macro from older Excel to Excel 365 for Mac

Occasional Visitor



I'm trying to import a macro that works on an older version of excel but does not work on Excel for Mac 365 Office version. When I debug, this is the portion of code that presents with the line bolded and underlined below is what is highlighted. Is there a quick way to edit this to work on my version of Excel?

Set MakeMenu = Application.CommandBars.ActiveMenuBar.Controls.Add _

(Type:=msoControlPopup, temporary:=True)

With MakeMenu

.Caption = "&SPC Macros"

Set MakeIDDistButton = .Controls.Add(Type:=msoControlButton)

MakeIDDistButton.OnAction = "Retrieve_Data"

MakeIDDistButton.Caption = "&Identify Distribution"

End With




0 Replies