how to make module global

[imtiyaz]

hi,
i have a small module in excel file (through VB editor). i want to make this module to be available for all the excel files. how to do it?
thanks in anticipation
husain

 

[dsi]

Look at "templates, customizing workbook defaults" in the Excel help file. It tells you how to create a default workbook template. You can add your code to that workbook and share it with others.

Hope this helps.

 

[imtiyaz]

thanks dsi,
the suggestion u gave works but actually, i was looking for how to convert the module as function or may be macro available for all excel file.
can u help for this.
bye
imtiyaz
take care