I have a macro-enabled workbook with several modules and class modules full of code. Two modules in particular are meant as UI entry points: PublicMacros and PublicFunctions. These are the only two modules with no Option Private Module statement: PublicMacros has nothing but Public Subs with no parameters, and PublicFunctions has nothing but Public Functions.
When I have the workbook open, I can hit Alt-F8 to see the Public Subs, and I can click the Formula ribbon's Insert Function tool and choose the User Defined category to see the Public Functions.
But when I save the workbook as an add-in (in %APPDATA%\Microsoft\AddIns), and I make sure the checkbox is on in the Add-Ins manager, I can see the Public Functions, but NOT the Public Subs! Is that normal for Excel? I swear I've seen add-ins' Public Subs before...
When I have the workbook open, I can hit Alt-F8 to see the Public Subs, and I can click the Formula ribbon's Insert Function tool and choose the User Defined category to see the Public Functions.
But when I save the workbook as an add-in (in %APPDATA%\Microsoft\AddIns), and I make sure the checkbox is on in the Add-Ins manager, I can see the Public Functions, but NOT the Public Subs! Is that normal for Excel? I swear I've seen add-ins' Public Subs before...
