Thursday, September 13, 2012 11:27 AM
I've been given a task to create an addin or template for excel which changes the ribbon.
The special requirement is that this change must affect only one workbook, this should make it possible for the user to continue it's work on other workbooks as usual.
Is there a known way to accomplish this?
I can already dynamically hide and show parts of the custom ribbon via getVisible callbacks on the ribbon xml combined with ribbon.Invalidate(), so maybe I should catch the WorkBookChange event and hide/show the ribbons accordingly... (?)
Thursday, September 13, 2012 11:53 AMModerator
If you create a VSTO document-level customization (workbook or template) any Ribbon defined as part of that solution should appear in the Excel UI only for that workbook / workbook created from the template.
Are you seeing something different?
Cindy Meister, VSTO/Word MVP, my blog
- Marked As Answer by Quist ZhangMicrosoft Contingent Staff, Moderator Tuesday, September 18, 2012 4:12 PM
Thursday, September 13, 2012 12:14 PM
Thank you for your answer.
I just checked and it works exactly as you've said.