I create a module in vb for excel sheet and this works very perfectly. But
each time i want to use this module in any other workbook either new or
previously saved, i copy this module in vb for that workbook which is very
irritating for me.
I want to make this module as default as other formulas are in excel. So
that, whenever i need to use this module/formula, i just enter the formula
and my need will complete.
Please give me an answer so that i will make my module as default as other
formulas like sum, if, countif etc.
Regards and thanks in advance for my help.

Instead of putting the code in a bunch of workbooks, you can create a workbook
that only holds that code.

Then you can use that code against any workbook.

Ron de Bruin explains it in detail he
http://www.rondebruin.nl/personal.htm

sohraaz wrote:

I create a module in vb for excel sheet and this works very perfectly. But
each time i want to use this module in any other workbook either new or
previously saved, i copy this module in vb for that workbook which is very
irritating for me.
I want to make this module as default as other formulas are in excel. So
that, whenever i need to use this module/formula, i just enter the formula
and my need will complete.
Please give me an answer so that i will make my module as default as other
formulas like sum, if, countif etc.
Regards and thanks in advance for my help.

--

Dave Peterson