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 _
.Caption = "&SPC Macros"
Set MakeIDDistButton = .Controls.Add(Type:=msoControlButton)