ActiveX controls cause Excel to Shutdown

  • Thread starter Thread starter omokeefe
  • Start date Start date
O

omokeefe

Last night I was doing some simple coding in VBA. The code applied to
two command buttons: one would copy and paste a line along with adding
a few check boxes, the other would delete said line and boxes. I
saved one of my first stabs at the code, and when I went to add
another command button Excel would shut itself down and auto recover
my previous work. I had been seeing the error "object library invalid
or contains references to object definitions" before this began
happening. I have Microsoft Office 2003 and have tried re-installing
it, to no avail. Every time I use the ActiveX controls (add a list,
check box, command button, etc.) Excel closes out. Anyone have any
ideas?
 
Just a guess...

Try cleaning up the windows temp file.

Close excel
Windows start button|Run
type:
%temp%
and delete as much as you can.

Then back to excel to test it out.

Too much junk in that folder can confuse excel.
 
Back
Top