Barring a UserFunction 2

[N1GHTEYES]

Two user-function questions:

1 I have a function I want to be able to use across a project in code (so I've got it declared as Public in a standard module), but I do NOT want it to be accessible from the spreadsheet "User Defined" functions list. I could re-cast the function as a Sub, but that would mean changing a bunch of other code that calls it, and it is neater to do it as a function anyway. So, does anybody know a way to bar a public function from the list of available UDFs?

2 When you call a function into a cell, using the drop-down list of available functions, the input screen gives a description of the function itself and the parameters. For a Used-Defined function, I know how to insert the general description, but I've not so far figured out how to insert the definitions of the parameters. Can somebody suggest a method please?

 

[PHV]

You may try to play with the Option Private Module instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[N1GHTEYES]

Thanks PHV - you're a star, so have one. I looked all over for that.

Got any ideas re question 2? I guess it's not vital to have descriptions for all the parameters, but it would be nice. It also impresses the hell out of my colleagues who are (even) less well versed in XL.

 

[combo]

You can either download Laurent Longre's add-in (

http://xcell05.free.fr/)

or use his code from Excel Experts E-letter, available at John Walkenbach web site (

http://j-walk.com/ss/excel/eee/eee009.txt).

combo

 

[N1GHTEYES]

Thanks combo. That looks like it is exactly what I was after. I guess that means they didn't provide a straightforward route to do it directly. I'm relieved, I was beginning to feel very dumb.

You also deserve a star, especially for the pointer to that useful-looking site.

2 questions, 2 replies, 2 solutions. What an excellent forum.