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?
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?