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="Dashbo...
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.