We have created an excel add-in that has a number of custom functions. Those functions are called from a custom tab that we have created and placed on the ribbon.
When certan functions are called from our custom ribbon tab (e.g. HypRetrieve, HypMenuVRefresh), the focus moves to the Essbase tab on the ribbon. We have tried everything we can think of to set the focus, but nothing seems to work.
We want to be able to click our custom "refresh" button on our custom tab, and have the focus stay there.