Restricted Functions
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" |
Restricted Functions
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 |
Restricted Functions
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 |
All times are GMT +1. The time now is 06:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com