Desktop Excel Add-in is able to programmatically set visibility on buttons, menus, groups, custom tabs in Excel ribbon to show or hide when different workbooks are activated.
Eg:
<button id="Dashboard" label="Dashboard" onAction="GotoSheet" getVisible="GetSheetVisible" imageMso="CategorizeMenu"/>
<tab id="ProductID" insertBeforeMso="TabHome" getLabel="GetLabel_Tab" getVisible="GetVisible_Tab">
However, the visibility isn't available in Office Add-in, other than custom contextual tab. Custom contextual tab is not suitable in my case.
I look forward to migrating desktop products to cloud platform, but the missing feature stops me moving forward. It'd be great if visibility feature will be available similar to the Enabled element.
Enable and Disable Add-in Commands - Office Add-ins | Microsoft Docs