Adding help text to custom functions in Excel

[jim4u]

Hi gurus,

I have an automation add-in created using C# for Excel, in which I am
exposing a number of functions. Is there any way I can add help-text
the way excel does for other categories like Financial, Statistical,
etc.

The place I want my help-text to be available is in the
Insert->Function. Here, we can select a category and function. The
corresponding help text is displayed. Now, my automation add-in is
also listed in this categories. I want help text to be displayed when a
user selects my add-in and functions in it.

I tried the MacroOptions method, but it is raising an exception.

Any help would be appreciated.... .

Jim

[jim4u]

This is the code I am using. I have tried both early and late binding.
I have also included the exceptions below.

early binding:

code:
_excelApplicati on.MacroOptions ("Report_Alloc" , "custom description",
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, "Report.Report" ,
Missing.Value, Missing.Value, Missing.Value);

Exception Message: "Exception from HRESULT: 0x800A03EC."
StackTrace " at
Microsoft.Offic e.Interop.Excel ._Application.M acroOptions(Obj ect Macro,
Object Description, Object HasMenu, Object MenuText, Object
HasShortcutKey, Object ShortcutKey, Object Category, Object StatusBar,
Object HelpContextID, Object HelpFile)\r\n at .......


late binding:

code:
object[] parameters = new object[10];
parameters[0] = "Report_All oc";
parameters[1] = "Some sample description..." ;
parameters[2] = Missing.Value;
parameters[3] = Missing.Value;
parameters[4] = Missing.Value;
parameters[5] = Missing.Value;
parameters[6] = "Report.Report" ;
parameters[7] = Missing.Value;
parameters[8] = Missing.Value;
parameters[9] = Missing.Value;

_excelApplicati on.GetType().In vokeMember("Mac roOptions",
BindingFlags.In vokeMethod | BindingFlags.Pu blic |
BindingFlags.In stance, null, _excelApplicati on, parameters, new
System.Globaliz ation.CultureIn fo("en-US"));

Exception Message: "Exception has been thrown by the target of an
invocation."
StackTrace " at System.RuntimeT ype.InvokeDispM ethod(String name,
BindingFlags invokeAttr, Object target, Object[] args, Boolean[]
byrefModifiers, Int32 culture, String[] namedParameters )\r\n at
System.RuntimeT ype.InvokeMembe r(String name, BindingFlags invokeAttr,
Binder binder, Object target, Object[] args, ParameterModifi er[]
modifiers, CultureInfo culture, String[] namedParameters )\r\n at
.......

Inner Exception Message: "MacroOptio ns method of Application class
failed"

Jim