View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Harker Norman Harker is offline
external usenet poster
 
Posts: 162
Default User Defined Function description

Hi Richard!

The same system is used for Excel 2003

Tools Macros Macro
Type in the name of the UDF
Options
Give a description
OK
Cancel

Just a couple of points.

First, you won't be able to access the option unless the project is
unprotected first.
Second, after inserting the description, you must go back into the VBE
and save the project if its in a XLA. If you don't, you'll lose the
description

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Richard" wrote in message
...
Previous to Excel 2003, you could provide a basic
description of a user-defined function that would appear
in the Insert Function dialog. This was done by going
into the object browser and selecting the function then
selecting properties (member options) and typeing in the
description.

Under Excel 2003, if you do this the description is
thrown away. I have tried this on several installations
of 2003 and all are the same. Is this by design or is it
a bug?