Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop a Procedure from another procedure | Excel Discussion (Misc queries) | |||
ATTRIBUTES | Excel Discussion (Misc queries) | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
Setting character attributes in a text string | Excel Worksheet Functions |