Hiding functions in add-in

R

RB Smissaert

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
 
R

RB Smissaert

I made a mistake here.
I have a general purpose installed .xla add-in that has many of the same
functions as
my main commercial app. This add-in didn't have Option Private Module and I
mistook the functions in that .xla for the ones in the big .xla!
This is great as it saves me a lot of hassle fixing it.

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top