Run Time Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Excel 2003. Every time I open a page in excel, whether new or for
editing, a Microsoft Visual Basic Run Time Error pops up that says: Method
'Add' of object "CommandBarControls' failed. I am no longer able to add any
patterns to a page or change the font color whether I go through the toolbar
or by right clicking and selecting "format cells". Does anyone have an idea
how I can fix this and get all formatting options available once again.
Thanks in advance.
 
I fixed it. I just read another post:

"It sound like you have a workbook open (possibly personal.xls), or an add-in
loaded with some event code in the Workbook_Close() event.

Try going to Tools>Add-Ins... and un-check everything. See if it goes away
and then add them back one at a time until the problem returns. If you have
loaded/updated adobe products I would suspect that as they seem to have some
real trouble with their add-ins.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)"

I had this add-in for a long time, maybe a year and it barely started giving
me problems. I really don't need it so it doesn't matter that I had to
uncheck it.

Thanks
 
Back
Top