Method "add" of object "commandbarcontrols" failed

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

I was working with customizing some menu bars ad I must
have accidentally deleted the file command bar from the
excel application. I have reinstalled / repaired and this
has not helped. Is there a way to fix this other than re-
installing office?
 
Paul,

I am guessing, but try these two suggestions:

1) View | Toolbars | Customize | Reset

If that doesn't work...

2) Find a file on your computer *.xlb. The xlb file is your toolbar setting
file. I would make a back up (say Excel.xlb to Excel.bac) and then delete
the xlb file (or, alternatively, just rename the xlb to bac). Excel will
create a new xlb file when it is opened.

I hope that one of the two suggestions work.

Regards,
Kevin
 

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

Similar Threads

Method ‘Add’ of object ‘CommandbarControls’ failed 1
Method of ... object failed in Excel 1
method add of object commandbarcontrols failed 3
Excel run time error message 5
HELP - 'Add' of object 'CommandBarControls' failed 1
Method 'Add' of object 'CommandBarControls' failed 3
method "add" of object 'commandBarcontrols' failed 2
Late Binding for Excel CommandBar and CommandBarControl 2

Back
Top