User-Defined Type Not Defined

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

Guest

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.
 
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
 
You must log in or register to reply here.

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

Similar Threads

User defined functions without programming. 5
User defined functions without using VBA. 2
Excel VBA Macro to do this? 19
User defined table function in XL2003 1
Populate XL cells with values from a user defined type 1
User defined type not defined? 2
Excel Not Seeing User-Defined Functions 2
User defined type not defined 1

Back
Top