Don't know why it won't take when adding descriptions through the Object
Browser with an Add-in but works OK with a workbook.

One of those Excel mysteries.


Gord


On Sat, 07 Mar 2009 19:49:18 -0500, Ron Rosenfeld
wrote:

On Sat, 07 Mar 2009 16:05:56 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

When UDF's are in an Add-in..........................

In Excel go to ToolsMacroMacros, type in the UDF name and "Options"

Type the description and OK

Do for other UDF's

Hit Cancel key to leave Macros dialog when done with adding the
descriptions.

Save the add-in. Or Excel will ask next you close Excel.


Gord

Yes, it works typing in the description in the macro dialog box within Excel.
But not in the Properties box when going through the VBA object browser. But I
think I'll just use the macro method.
--ron