Option Private Module

  • Thread starter Thread starter RB Smissaert
  • Start date Start date
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
 
What was happening?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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
 
Thanks for sharing, I must admit to having been intrigued by your original
'problem'

Bob
 
Back
Top