Restricted Functions

  • Thread starter Thread starter K_Macd
  • Start date Start date
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
 
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.
 
Back
Top