View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default common functions:where to put them?

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?