instead of making your functions Private, put them in a common module
and put
Option Private
at the top. That way, they're unreachable to other projects (and XL's
macro dialog won't list them), but any Sub in the project can utilize
them.
In article .com,
wrote:
Since all are Private, I have had to make copies of them in each of the
5 modules that use them. Other than making them Public, how would the
group suggest I get away from this duplication?