How to activate number of Function?

[Cap2010]

hi,

I have prepared number of functions and have to create
number of modules.

What I want is to all the functions in one module only?

What happens is only one function is activated and not the
others. (None has inter connection also)

How do I make all function stored in one module and
access all the functions through Excel?

Thanks,

Cap

 

[acron]

Save the workbook with the functions as an Add-In (filename.xla) and save it in your XLSTART folder. That should ensure it is available to all workbooks.

A.C

 

[scking]

Actually when you save it as an Add-In by changing the file Add-In property to true the macros are no longer available for general use. You can accomplish the same thing as acron mentioned by following his guidance but, rather than setting it as an add-in, hide the workbook. It will then load on start, not show any worksheets, and allow the macros to be used globally. Excel actually encourages this by creating a PERSONAL.XLS macro repository. ----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------