Forum Discussion
Michael_Yehl
Jul 09, 2020Copper Contributor
Importing Macro from older Excel to Excel 365 for Mac
Hi,
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
Thanks,
Michael
No RepliesBe the first to reply