Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing macros using VBA
Hi
in the VBA editor goto 'Tools - References' and check if all required references are set -- Regards Frank Kabel Frankfurt, Germany "jgranda" schrieb im Newsbeitrag ... I am using the code from the pearson website but there is a case of user error - me. I am receiving the following error message: "Compile error: User-defined type not defined" The code I am using is: Sub DeleteModule() Dim VBComp As VBComponent Set VBComp = ThisWorkbook.VBProject.VBComponents("Module1") ThisWorkbook.VBProject.VBComponents.Remove VBComp End Sub When I run the debugger, it is highlighting the line Dim VBComp As VBComponent. Can someone give me advice on how to correct? Thanks, Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Macros | Excel Worksheet Functions | |||
Removing macros from workbook | Excel Discussion (Misc queries) | |||
Removing circular references without the use of macros? | Excel Discussion (Misc queries) | |||
removing unwanted macros... | Excel Discussion (Misc queries) | |||
Removing Macros | Excel Programming |