it is not possible to creating or editing UserForm in Excel VBA for Mac.

Allow Mac users to access all add-ins such as Power Query. We are paying the same price but getting inferior service.

Rather than make Macro behavior global, give us the ability to Enable them within individual Workbooks so we don't have to see the alert dialogue each time that Workbook is opened. I would suggest putting a setting in the Properties and adding a button/link to the dialogue options.

Solver shows in the tools but it doesn't work after bing selected.
Please solve it !!!

Allow Mac users to refresh a Power Query that gets files from a folder (and was created with windows).

Bring VBA on Excel for Mac to parity with Excel for Windows.

Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

Why is the not being addressed?

Msgbox "Hello", vbQuestion show the same window (with the same logo on the left) as Msgbox "Hello", vbInformation or Msgbox "Hello", vbExclamation although it is fine with Msgbox "Hello", vbCritical

UserForms are not available in excel for Mac users

On Windows, Ctrl+Break can be used to interrompt a macro (for instance, stuck in an infinite loop).

Excel 2011 used to have this option too, via Cmd + .

However, this shortcut doesn't work on the latest versions of Excel for Ma and there is no way to interrupt a macro except than force quitting.

(Tested on 'classic' Excel 2016, and 'Mac App Store' edition of Excel 16.28).

I recently notice that files saved with Office 2016 do not work on Office 2019 (16.26) and vice et versa. Either crash or showing compilation error or internal errors with librairy. It was not the case with Office 2019 (16.25).
Please fix...

Das folgende VBA-Programm erzeugt in der dritten Zeile einen Überlauf-Fehler:

Sub Test()
Dim a As Double
a = 18.9
End Sub

Auf Windows läuft das Programm fehlerlos. Bitte korrigieren.

ExportAsFixedFormat method produces a "Run-time error '1004':

Application-defined or object-defined error" when trying to save (export) a pdf to a user folder (/Users/user/Documents for example)

As I see it only works if one saves to the sandbox path of Office (Library/Group Containers/UBF8T346G9.Office), which is quite uncomfortable to work with.

When a macro is added to the QAT, it displays as a circle in the toolbar. Add another, you get another circle. Unless you memorize what you added and the order you added them, you don't know what you're selecting. The list for customizing the QAT shows them as <<No label>>. You can name them with the Rename option on gear at the bottom of the dialog, but they revert back to no label after you exit the dialog.

There appear to be critical compatibility issues between 2011 and 2016 for Mac.
I've written a lot personal finance code. I need to load externally generated tab separated data and expressions into excel cell ranges. I export named range tables so my external code can inter-operate with Excel 2011. The macros I wrote to do all this in Excel 2011 don't run correctly in Excel 2016. I need a comprehensive Macro/VBA migration guide. I can't switch to 2016 until these macros have been ported.

It would be excellent if we had facilities to scan a barcode from a hand held scanner in to an invoice

I would like to enter a customized footer for each excel sheet that I print. For example page 1 footer is different that page 2 but I still able to keep the feature of all of them having a consistent page number.

Since 16.15, running the following AppleScript has either crashed Excel (versions 16.16–16.23) or (16.15 and since 16.24) produced a badly formatted HTML file.

tell application "Microsoft Excel" to save as active sheet filename theFolder & "test.html" file format HTML file format

Note that theFolder is a valid folder in the Office sandbox folder. The equivalent code in VBA works fine:

ActiveSheet.SaveAs FileName:=theFolder & "test.html", FileFormat:=xlHtml

Alternatively, could the VBA PublishObject object be added to the AppleScript dictionary?