Excel run time error message


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?
 
Ad

Advertisements

S

Shane Devenshire

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

wschofield

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
 
S

Shane Devenshire

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

wschofield

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
 
Ad

Advertisements

W

wschofield

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
 
Ad

Advertisements


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