User-Defined Type Not Defined

L

LindaG

Seemingly all of a sudden I get the message User-Defined Type Not Defined
every time I enter data into any spreadsheet cell. I do not use VB or macros
or anything fancy. I don't remember hitting an odd key or ending up in an
odd area of Excel. I tried opening a new spreadsheet and the problem
persists. I use Excel 2002.

How can I stop this from happening? Thank you.
 
C

Chip Pearson

Do you have any add-ins loaded? If so, it is probably an add-in
misbehaving. Go in to the VBA Editor, and for each project listed
in the Project Explorer (CTRL+R to view it), go to the Tools menu
and choose References. See if any are marked MISSING. If so,
uncheck them.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top