Maybe a noobish question, but here it goes:
My goal is to install an Excel Add-in.
I have all the code in a Module, organized in several Sub()s. I saved the Add-in in the Excel Add-ins folder. When trying to add the Add-in as a button/custom menu
(File/Options/Customize Ribbon/Macros), I see all Sub()s listed.
Is there a way to hide some of the Sub()s from being listed ? I only need the main one; displaying all of them becomes confusing when using multiple add-ins, especially since most of the Sub()cannot run be run by themselves. Are there any good practices for organizing the code in order to prevent this ?
If you write Option Private Module on top and you make the subroutines private, they would not be visible.
See more here for Option Private Module.