View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GreenInIowa GreenInIowa is offline
external usenet poster
 
Posts: 38
Default User defined functions: Where to keep in VBA?

Hi,

I would like to define some functions and would like these to be available
to me all the time (regardless of what workbook I am working with).
1) Where should I store them?

2) Related to this question, let say that I stored them locally in my
computer (Personal.xls) and then I decided to send my files to someone who
needs to see the results calculated by these functions. Can he see them? If
not, how can I ensure that he can see.

Thanks.