error message Method ‘Add’ of object ‘CommandBar Controls’ fail?


Sandy Pringle

When opening 2007 Excel I get the following message:

Run-time error ‘2147467259 (80004005)’
Method ‘Add’ of object ‘CommandBar Controls’ failed

Program seems to work OK.
Is there something I need to do?

Jim Thomlinson

2007 does not have a command bar. It uses the ribbon. Hard to add something
to a command bar that does not and can not exist. The code will need to be
changed if the command bar is required.

Dave Peterson

The commandbar code should still work. Any toolbars created will show up on the
Addins tab of the ribbon.

(I don't have a guess why the OP's problem occurs, though.)

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