Thread
:
User Defined Function description
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Harker
external usenet poster
Posts: 162
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?
Reply With Quote
Norman Harker
View Public Profile
Find all posts by Norman Harker