View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sohraaz sohraaz is offline
external usenet poster
 
Posts: 3
Default Module of VB sets as default on Excel

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.