View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
LEELK01 LEELK01 is offline
external usenet poster
 
Posts: 2
Default Excel Message "user defined type not defined"

There is no code placed in those sheet icons & "This workbook" icon but
anyway the problem has been solved by re-open the file.

Thanks a lot.

"Jacob Skaria" wrote:

When you say no macros; have you checked the worksheet and workbook events..

Launch VBE using Alt+F11. From the tree view under VBAProject for this
workbook double click the sheet icons and the 'This workbook' icon and see
whether there is any code placed. You may receive this error message when a
subroutine contains code that use an Object Library and the library is not
referenced...under VBE ToolsReferences....

If this post helps click Yes
---------------
Jacob Skaria


"LEELK01" wrote:

Dear Sirs

System keep on prompt me message "user defined type not defined" while input
any data in the excel file which no macro on that workbook. It's troublesome
have to click "OK" each time when message prompt.