Restricted Functions

K

K_Macd

Occassionally one writes a function that returns a value in a macro
environment but it may not make much sense to have that function exposed in
sheet mode. Can one specify that a UDF be hidden from sheet operations?

TIA
 
P

p45cal

K_Macd;505209 said:
Occassionally one writes a function that returns a value in a macro
environment but it may not make much sense to have that function
exposed in
sheet mode. Can one specify that a UDF be hidden from sheet
operations?

TIA
Click to expand...

You can prefix the the function with 'Private' in the code, which will
prevent its appearance in the UDF list.
 
K

K_Macd

Thanks for your response

That will achieve the result but will make it too private ie it would not be
available to other projects so the question is whether one can set an
intermediate level of visibility - available to any macro in VBA but never in
sheet mode.
 
Top