excel vsto addin/template custom ribbon for one workbook

Question

Hi Everybody,

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... (?)

Thanks,
Michael

Answer 1

Hi Michael

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

Answer 2

Hi Cindy,

Thank you for your answer.
I just checked and it works exactly as you've said.

Thanks,
Michael