Excel run time error message

  • Thread starter Thread starter wschofield
  • Start date Start date
W

wschofield

Every time I open Excel I get an error message and would like to know how to
get rid of it. See message below.

Run-time error '-2147467259 (80004005)':
Method 'Add' of of object 'CommandBarControls' failed

Is there any way to get rid of this message?
 
Hi,

There is probably a macro in the workbook. If this happens when you start
Excel then it is probably in the Personal Macro Workbook or in the default
workbook.

Check in the VBE for any macros and consider removing them.
 
Thank you Shane. I am afraid I don't know how to (or what) VBE. If I go to
macros in excel it is blank shows no macros
 
Hi,

1. Press Alt+F11 - you will be in the VB Editor (VBE)
2. If you can see the Project Explorer, the top left corner window, your
file should be listed there and maybe other ones.
3. Click the plus beside your file if necessary to see the list of sheets -
Sheet1, Sheet2, Sheet3...., thisWorkbook.
4. If there is a Modules folder, open it and double-click and copy the code
you see and post it here.
5. If there is no Modules folder then double click the thisWorkbook object
and see if there is code there, repeat this step for each sheet.

If there are any other projects listed in the Project Explorer other than
your workbook let us know what they are.

If there is a Personal Macro Workbook, use the steps described above to
check for code. Post whatever you find here.
 
Sheets 1,2 & 3 have the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub

Thisworkbook has the following:
Private Sub Workbook_Open()
End Sub
 
Sheets 1,2 & 3 have the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub

Thisworkbook has the following:
Private Sub Workbook_Open()
End Sub
 
Back
Top