View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Hiding functions in add-in

Have a large add-in with lots of public functions.
This .xla is opened but not actually loaded with Tools, Add-ins.
How do I avoid all these functions appearing under the User defined
worksheet UDF's?
I thought Option Private Module would do this, but it doesn't.
I could put them in a worksheet module, but I will then get a very large
extra module.
I suppose I could make lots of worksheet modules but that somehow doesn't
seem quite right.
What is the best approach for this?

RBS