Add-in Functions Not Available

[jomili]

I've created an add-in, and put all of my favorite macros and UDFs in it. I used Ron Debruin's "MyAddin.xlam" to do it, and so I have a nifty menu to call all my macros, and they're all working just fine. My problem is my UDFs; when I'm in a workbook and click my Fx button, I don't see the functions listed individually, nor do I have a listing for "MyAddin's Functions". If I click on "UserDefined" they're not listed there either. What do I need to do to be able to use the UDFs contained in my addin?

Thanks,
John

[JosephP]

are the udfs all in normal modules, not marked with option private module?

[jomili]

All of the the Macros and Functions are in the "MacroModule", which IS marked "Option Private Module". That comes standard with Ron's "MyAddin.xlam". All of my macros are accessible leaving it marked that way, but should I move my functions out of that module into one that doesn't have the "private" option at the top? Or, would it better to remove "Private" from my MacroModule?

My intent for this addin is that, once I have it working right for me, I want to roll it out to the rest of my team. How does the "Option Private Module" affect that?

[romperstomper]

Yes, move the functions you want visible to a module that is not marked Private. The whole purpose of that is to hide routines from the UI.

[jomili]

Easy enough. But for my continuing education, should I leave the module containing my macros marked private? And if so, why?

Thanks.

[romperstomper]

With an addin it doesn't really matter since they won't appear in the macros dialog anyway.

[jomili]

Got it. Thanks.