Jul 09 2020 04:18 PM
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