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
|