Thank You, I have already tried both these posts. I cannot get them to work
in Excel 2007 or Excel 2003 however I have found that they will work in Excel
97 of which fortunately I still have a copy. Can you get your suggestions to
work in Excel
2007?

"Bob Phillips" wrote:

You can add a brief description(not arguments) if you open the VBEditor and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

This comment will be shown in the Function Wizard when you click on your
UDF.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Normek" wrote in message
...
Description text in Macros
Windows help files show you how to add a description in custom Macros.
I have tried to follow this but with only one success, and I haven't been
able to reproduce it or edit the description.

There appears to be a step missing. Has anyone tried to add a description
to
their macros or functions or edit the descriptions and succeeded?

I know that you can add the description when you are recording the macro,
successfully but I can't subsequently edit it.