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.
https://docs.microsoft.com/en-us/office/dev/add-ins/design/disable-add-in-commands
1 Comment
My company needs this as well. In our VSTO add-in, we show/hide ribbon buttons based on things like permissions or whether a function is available for the current data source.
