Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions: Where to keep in VBA?
Probably creating an addin would work better for you. Place all of the
function that you want in a workbook and save it as an addin. It is easy to distribute and a handy way to add general utilities and functionallity. There is lots of info on creating addins on this site if you search for it. -- HTH... Jim Thomlinson "GreenInIowa" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions: Where to keep in VBA?
I thought there may be another way around. Thanks for your response, Jim.
GreenInIowa "Jim Thomlinson" wrote: Probably creating an addin would work better for you. Place all of the function that you want in a workbook and save it as an addin. It is easy to distribute and a handy way to add general utilities and functionallity. There is lots of info on creating addins on this site if you search for it. -- HTH... Jim Thomlinson "GreenInIowa" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
USer defined functions | Excel Programming | |||
user defined functions | Excel Programming | |||
User defined functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |