Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Message "user defined type not defined"
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Message "user defined type not defined"
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Charts-Missing the "Add-Delete" Options. | Excel Discussion (Misc queries) | |||
User Defined Charts-Missing the "Add-Delete" Options. | Excel Discussion (Misc queries) | |||
How do you save and share "user-defined chart type's" in Excel? | Charts and Charting in Excel | |||
How do you save and share "user-defined chart type's" in Excel? | Charts and Charting in Excel | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) |