View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default EXcel Functions in VBA

Tony,
Does Option Private Module do what you need ?

NickHK

"Tony McGee" wrote in message
...
I have written an addin which amongst other things has some custom

functions
available for general use (under the User Defined Category) once the addin
is installed.

However, I also have some functions I would only like available for use by
my VBA code. Is there any way I can make these functions "publically
available" to all of my code, but NOT appearing in the Excel Insert

Function
list.

Thanks
Tony McGee