UDF as a Add-in wont add description of variables

[jed38]

i created a function in vba and saved it as a add-in. I want to add the variable descriptions so when a user goes to use the function they can get a description of what each variable is.
here is the function and then the sub to add the desc.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I tried calling the ChevronMarking_Desc sub on an on open event but i think because it is a add-in and the workbook is hidden i got an error saying. cannot edit a macro on a hidden workbook this error happens when on the Application.MacroOptions line.
The formula itself is working
Anyone know how to get the desc of variables to show when on the Insert function wizard???
thanks
JD

[mikerickson]

Have you opened the Macro Dialog box, selected Options and entered the description in that?

[jed38]

I wrote the code in excel VBE and everything worked, once saving it as an add-in the descriptions arn't being added

Please Login or Register  to view this content.

this last line no longer works. It has something to do with the workbook being hidden.
I'm not sure what you a talking about in the macro dialog box, the options button doesnt open anything when i click on it. the main part i want to to add the ArgumentDescriptions in the macroOptions for the UDF.

[Izandol]

I think this will show a way: http://www.jkp-ads.com/Articles/RegisterUDF00.asp

[jed38]

here is a much easier solution.
i just added workbooks.add in the code below

Please Login or Register  to view this content.

and this code in the ThisWorkbook

Please Login or Register  to view this content.

then save it as a add-in.
open excel and add it in your add-ins. then it works perfectly.