Errors when customizing quick access toolbar in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2007, where a custom ribbon tab with VBA callbacks is present, if
one uses Customize to customize the quick access toolbar and selects one's
custom tab as the source of controls, Excel displays a series of error
messages headed "Microsoft Visual Basic" but with no content, one message for
each callback.
 
This should work. If you still have this issue I'd like to take a look and
see what's going on with it.
 
It's a problem which was present in the Beta and B2TR (reported at the time)
and which continues into the live version.
 
I have a test workbook which demonstrates the problem. If you let me have
your email address I can send it to you.
 
Has anyone found a solution or workaround?

It seems the getLabel functions for the buttons and what not on the custom ribbon aren't registered yet when one goes to the Quick Access Toolbar->More Commands before having clicked on the custom ribbon group. When replacing getLabel with static labels a la label="mybuttonlabel" or when having clicked on the custom group first, everything works.
 
Back
Top