Option Private Module

R

RB Smissaert

Have used Option Private Module in all modules with functions to avoid these
functions showing up under the User defined worksheet functions.
This worked nicely, but now for some reason all the functions do show again
in the UDF category.
Any ideas why this could be?

RBS
 
B

Bob Phillips

What was happening?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
R

RB Smissaert

What was happening was that I made a mistake I had made before.
There is another add-in with similar functions.
This didn't have Option Private Module, so all the functions showed up.
Simple and silly!

RBS
 
B

Bob Phillips

Thanks for sharing, I must admit to having been intrigued by your original
'problem'

Bob
 
R

RB Smissaert

No problem.
Any suggestions about the other post:
Application.OnKey etc ?

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

Similar Threads

Hiding functions in add-in 1
Option Private Module 2
Improve method of calling a private function in a private module 1
Option Private Module 3
How to call user defined function (UDF) from custom menu in Excel2003? 3
Multiple User Defined Categories in Insert Function Form 2
User Defined Function being called by changes to an independent workbook 13
Option Private Module (for Object Modules) 5

Top