I have an Excel VBA application that makes use of a lot of windows functionality view Declare Function and Declare Sub.
The functions that are used are typically declared Private in the module in which they are used. I am thinking of putting all these function declarations from all the modules in their own module where they would be declared Public.
Is there any reason why I wouldn't do this? what are the advantages / disadvantages, if any of using one versus the other?