William,
Export the class file to a text file, edit that file in Notepad or your
favorite text editor, and modify the code so it looks like the following:
Public Property Get NewEnum() As IUnknown
Attribute NewEnum.VB_UserMemId = -4
Set NewEnum = mCol.[_NewEnum]
End Property
Then, import the cls file back in to your VBProject.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
"William H. Burling" wrote in message
ink.net...
I am in a VBA (excel 2000) environment....which does not have an item in
the
tools drop down list box which allows me to set procedure attributes which
I
need to do for NewEnum(procedureID needs to be set
at -4). Does anybody know how to do that in an VBA environment?