Recovering the ribbon in Excel 2007 after an error

A

Andrew B

I have been programming the ribbon in the Excel 2007 beta to create a custom
tab, using callbacks from VBA, and have encountered the following problem: if
the program terminates for any reason (e.g. an error or an End statement),
the ribbon object returned from the onLoad event is lost. There is then no
way to invalidate the ribbon. Is there any way to get this object back again?
The only way I have found is to close and reopen the add-in containing the
ribbon XML, but this seems rather heavy-handed, and also has the effect of
switching the user off my custom tab and back to the home tab. If there is no
other way to do it, is there any way to activate my custom tab after
reopening the workbook?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top