Excel VSTO/VBA Events for opening Backstage window in Excel

Question

does any one know if there is an event some other trigger for the opening of the Backstage window? I tried already using the ribbonUI, and am currently looking for windowhooks on childwindows in Excel. Any info is welcome. I will keep this updated. FYI it is not triggered using the standard Excel events (like windowactivate). Thanks in advance,

regards Arie

Answer 1

Ok i solved it using an XML ribbon and using the

<backstage onShow="OnBackstageShow" onHide="OnBackstageHide">      </backstage>

this works like a charm. Thanks for thinking :)

Answer 2

If you add a control to the Backstage (such as a button), try to use a callback for one of its properties (e.g. getLabel) - when it fires, you know the host app is about to display the Backstage.