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