is there way to hide function from Excel interface

[Guest]

Hi,

I got few functions(GroupA) which get called by few other functions
(GroupB). IS there way to hide this function so that when user go to
Insert/Functions.../USer Defined, they can't see it?

Thanks
Augutus

 

[Nick Hodge]

Augustus

Mark it as private

Private Function myFunction()

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Robin Hammond]

Or,

at the top of the code module in which the function resides, add

Option Private Module

You can then make your function Public, so that it can be used by other
parts of your code, but because the module is private, the function will not
appear in the list of UDFs in the insert function wizard.

Robin Hammond
www.enhanceddatasystems.com

 

[Guest]

THanks Nick & Robin

Or,

at the top of the code module in which the function resides, add

Option Private Module

You can then make your function Public, so that it can be used by other
parts of your code, but because the module is private, the function will not
appear in the list of UDFs in the insert function wizard.

Robin Hammond
www.enhanceddatasystems.com