In VBA, go to the Tools menu, choose References, and select
"Microsoft Visual Basic For Applications Extensibility Library".
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"michaelberrier" wrote in message
ups.com...
I'm trying to use a macro to delete all VBA code in a workbook,
and the
very beginning starts with "Dim myVBA As VBIDE.VBComponent".
This
causes a "User-Defined Type not Defined" error. I've seen that
used in
other macros and in a handful of entries on this group, but I
can't
make heads or tales of it or how to make it work for me.