Errors when customizing quick access toolbar in Excel 2007

A

Andrew B

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.
 
R

Renee [MSFT]

This should work. If you still have this issue I'd like to take a look and
see what's going on with it.
 
A

Andrew B

It's a problem which was present in the Beta and B2TR (reported at the time)
and which continues into the live version.
 
A

Andrew B

I have a test workbook which demonstrates the problem. If you let me have
your email address I can send it to you.
 
J

Johannes Kienzle

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.
 

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