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.