Adding descriptions to user defined functions 1

[JTBorton]

Excel 2003
I've got quite a few functions and I'd like to add some descriptions to them for other users. I pulled them up in the object browser, right clicked and selected Properties, entered the function description and clicked OKAY, but it wont take.

I've tried the same method with a new excel sheet and a test function and the description takes just fine.

Any ideas as to why this particular excel sheet won't let me add descriptions to my functions?

-JTBorton
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]

 

[combo]

It can be only a problem with refreshing data in object browser. Try to export module and see it in notepad.
The description is under function definition:
[tt]Attribute FunctionNameHere.VB_Description = "Function description text"[/tt]

combo

 

[JTBorton]

Thanks combo, that fixed it right up!

-JTBorton
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]