Adding hints to my vb functions
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
On Sat, 07 Mar 2009 13:59:01 -0500, Ron Rosenfeld
wrote:
Although that method seems to work OK for a VBA project, I tried it with an
**add-in** and the description "doesn't take".
By that I mean if I right-click on the UDF name; enter something in the
Property dialog box; hit <OK. When I immediately re-open the property dialog
box, the entry is blank.
|