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

Augustus

Mark it as private

Private Function myFunction()

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"augustus" wrote in message
...
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

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


"Nick Hodge" wrote in message
...
Augustus

Mark it as private

Private Function myFunction()

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"augustus" wrote in message
...
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

THanks Nick & Robin

"Robin Hammond" wrote:

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


"Nick Hodge" wrote in message
...
Augustus

Mark it as private

Private Function myFunction()

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"augustus" wrote in message
...
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