Common Module

Anurag
There are a number of ways to do this.
You can create a workbook called "personal.xls"
and import the .bas file to this module then
save it your excel start dir
C:\Program Files\Microsoft Office\Office\XLSTART
This will make the macros available to your excel
applications when starting up excel.
or you can save the .bas module to a workbook and
save it to a dir you setup for this perpose eg name
it say "MyFunctionAccess".
When you want another workbook to access these
functions then in the VBA editor select <Tools>
<referemces> and browse for the file in the
"MyFunctionAccess" Dir. Select this and it becomes
avail. for your current workbook.

regards

Ivan

PS otherwise just import it to the file you want.

The above has been amended as I had text enclosed
in scripting brackets that never appeared.
Sorry

Ivan