ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   setting procedure attributes (https://www.excelbanter.com/excel-programming/275972-re-setting-procedure-attributes.html)

Chip Pearson

setting procedure attributes
 
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?










All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com