AppProtect and QuickLicense can generate a Mac APP file that works with either Mac Excel 2011 or 2016 using the popular Encrypted XLSM Approach.
QuickLicense also supports the VBA Bound License approach. With this approach, a few extra steps are needed during the install process (or handled by an included Setup program) to prevent excessive Grant Permission requests in the user experience. OfficeProtect user documentation describes how to handle this.
Instruct the user to enable Macros in the Preferences dialog before running your application.
Office 365 Bug
QuickLicense 9.0.3 and OfficeProtect 4.0 on macOS introduced an effective work-around to this Excel bug as described below.
The bug is known to occur in version 16.16.x and not occur in older versions like 16.12. Microsoft indicated that they are aware of the problem and working on a solution. Microsoft recommends installing an older version of Excel.
Here is the link to install a known working edition of Mac Excel if you have Office 365:
Excel Installer without VBA Bug
Before installing, you’ll need to drag your Excel app from the Applications folder to the trash and empty the trash. If you have a launch icon in the Dock, remove that too.
After installing, Excel will likely hang up the first time you run it. Now force quit Excel from the Finder menu. Run Excel again and it should work fine thereafter.
Disable Microsoft Auto-Update
When running an Excel workbook, users must be extremely vigilant to avoid the periodic notifications and popup requests to upgrade Excel. Otherwise, the user will unknowingly install the buggy version of Excel again. That starts a long process to restore a stable Excel environment.
Click the Check for Updates button displayed in a workbook to present the Microsoft AutoUpdate screen. Make sure the Manually Check radio button is selected.
Office 365 Bug Workaround
Developers using a VBA Bound License will also want to use the enhanced VBA code provided with OfficeProtect 4.0. To support Mac Catalina, a new 64-bit SetupExcelSandbox app is included with OfficeProtect 4.0.