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

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

K_Macd;505209 Wrote:
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

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

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


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=138937

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.
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"p45cal" wrote:


K_Macd;505209 Wrote:
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

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

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


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=138937