For several years I have used the following code to disable/enable commandbar controls, but since updating to Excel 2016 for Mac it no longer works:
' Controls the enabling/disabling of all controls with the specified Id.
Private Sub EnableControl(pintCtrlId As Integer, pbooEnable As Boolean)...