If I pull up a user-function in the object browser, I can enter or edit a description of the function. Can somebody please tell me how I could access that description in code?
If you're interested, the reason I ask is as follows.
I have an .xla I tend to use to keep most of my useful macros and functions. It gets upgraded fairly often and a few of my colleagues use it too. It seems like it would be easiest to include a sheet in the xla which had a listing of: all of the functions, when they were added, why, their inputs, outputs, external effects & so on. It could also have a column for the descriptions. If I could then get the xla code for "Thisworkbook" to copy the descriptions to the userfunction descriptions on startup, it would mean that I'd only need to enter them in one place and I'd always be sure they were available to the users at the latest version.
If you're interested, the reason I ask is as follows.
I have an .xla I tend to use to keep most of my useful macros and functions. It gets upgraded fairly often and a few of my colleagues use it too. It seems like it would be easiest to include a sheet in the xla which had a listing of: all of the functions, when they were added, why, their inputs, outputs, external effects & so on. It could also have a column for the descriptions. If I could then get the xla code for "Thisworkbook" to copy the descriptions to the userfunction descriptions on startup, it would mean that I'd only need to enter them in one place and I'd always be sure they were available to the users at the latest version.