The visual basic for applications editor for the Mac does not have the ability to edit keyboard shortcuts. The most common editing shortcut used is to step through code while debugging. In windows VBE this is F8, and those of us who are familiar with the windows version would like to have the same experience on the Mac. The current keyboard shortcut requires two hands and makes it very awkward to step through and debug your code.

According to Madoc Huang MSFT in the Microsoft community forum, I should post this here because this feature is not available on the Mac.

FF8 is not possible because I know it is special, then you should allow F7 or F6 or F5.

Excel for Mac version 16.15 does not open xlsm files from Excel for Windows !

Excel has a very serious error:
Do not open the xlsm files maked with Excel for Windows, please correct it... !!!
 

I have tried it with all my previous excel macros files and in all it sends me a message of ERROR, when accepting that, Excel proceeds to repair it deletes all the macros that you have programmed in VBA !!!

What kind of error is that ???

PLEASE CORRECT THAT HORROR !!!! ...

The exact message is the following:

Notice: 
We have found a problem with 'book.xlsm' content. Do you want us to try to recover as much content as possible? If you trust the origin of this book, click Yes.

When I answering YES, all the VBA code is deleted and lost !!!
Very careful Danger of losing your VBA macros !!! 


Microsoft: ¡ please correct this error !

The next version of MacOS will will not allow the editing of UserForms in Excel so I've installed a virtual machine (Parallels) with the current MacOS which I will not update when the new version comes out. I can currently run all of my excel spreadsheets (Excel for Mac 2011) using this (they all run flawlessly) and will be able to update my main OS to the new version.

Actually, I have installed all of my 32 bit applications on the virtual machine.

This a lot cheaper than buying a dedicated Windows computer.

Now I have all the benefits - two computers in one with all the advantages of both.

(I have no form of business association with Parallels.)

I Purchased Office 2019 (one time purchase) on 24 Jan 2019
at Mac Centre Norwood (Adelaide South Australia) Apple Shop

Having Problems so for now have gone back to Office 2011 Default Excel AND VERY WORRIED THAT NEXT MACOS WILL NOT SUPPORT THAT OLD OFFICE VERSION:

Excel in Microsoft Office 2019 is slow to open - two minutes versus 8 seconds in Office 2011 if opening a saved workbook on my Mac book pro MacOS Mojave 10.14.2 by double clicking workbook file icon. Workaround seems to be opening Excel first from which the file is opened but that still takes 8 seconds whereas with Office 2011 it is immediate if Excel is opened first.

I hypothesise that the delay could be related to Office 2019 common services trying to handshake with system resources in the Mojave OS when Office expected the Sierra OS.

A second big issue is after extensive changes were made in the VBA embedded in an Excel workbook, admittedly running in Compatibility Mode, the Workbook could not be saved and so the work was lost. Apple Case ID: 100742389363 31 Jan 2019. Use that number to review your case.

If a workbook is enhanced with VBA changes using Excel in Office 2019, one might want that workbook to be portable to another Mac with a different OS or even a Windows machine. Multiple platform utility is one of the big selling points of implementation in Excel. It seems such an enhanced workbook is corrupted from the perspective of even the earlier mac Excel in Office 2011. The change tested was simply placement of linefeeds in an alert dialogue!

Annoying too is the width of text strings in alerts & dialogues is much shorter than in Office 2011 and also has unexpected unnecessary line feeds fragmenting text.

I downloaded the package directly from Microsoft, not realising I could have ordered it on the Apple App Store from which updates to eventually fix such issues might have been automatic. How do I organise getting fixes to the product at some point?

Noticed too having opened an existing significant Word document created in Office 2011, that in Office 2019 it can not update the Index for that otherwise unchanged document.

I Purchased Office 2019 (one time purchase) on 24 Jan 2019
at Mac Centre Norwood (Adelaide South Australia) Apple Shop

Having Problems so for now have gone back to Office 2011 Default Excel:

Excel in Microsoft Office 2019 is slow to open - two minutes versus 8 seconds in Office 2011 if opening a saved workbook on my Mac book pro MacOS Mojave 10.14.2 by double clicking workbook file icon. Workaround seems to be opening Excel first from which the file is opened but that still takes 8 seconds whereas with Office 2011 it is immediate if Excel is opened first.

I hypothesise that the delay could be related to Office 2019 common services trying to handshake with system resources in the Mojave OS when Office expected the Sierra OS.

A second big issue is after extensive changes were made in the VBA embedded in an Excel workbook, admittedly running in Compatibility Mode, the Workbook could not be saved and so the work was lost. Apple Case ID: 100742389363 31 Jan 2019. Use that number to review your case.

If a workbook is enhanced with VBA changes using Excel in Office 2019, one might want that workbook to be portable to another Mac with a different OS or even a Windows machine. Multiple platform utility is one of the big selling points of implementation in Excel. It seems such an enhanced workbook is corrupted from the perspective of even the earlier mac Excel in Office 2011. The change tested was simply placement of linefeeds in an alert dialogue!

Annoying too is the width of text strings in alerts & dialogues is much shorter than in Office 2011 and also has unexpected unnecessary line feeds fragmenting text.

I downloaded the package directly from Microsoft, not realising I could have ordered it on the Apple App Store from which updates to eventually fix such issues might have been automatic. How do I organise getting fixes to the product at some point?

Noticed too having opened an existing significant Word document created in Office 2011, that in Office 2019 it can not update the Index for that otherwise unchanged document.