is there way to hide function from Excel interface
 

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

is there way to hide function from Excel interface
 

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

is there way to hide function from Excel interface
 

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

is there way to hide function from Excel interface
 

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