How to add user defined functions in excel permanantly

[Sandeep Jangra]

I made a function in vb and now I want to add that function in excel
permanantly. Whenever I start excel it should be loaded automaticaly. Plz
help me on this....

 

[Mike H]

Hi,

2 options.

Make it and add-in or save the UDF in Personal.xls

have a look here for creating addins
http://www.ozgrid.com/VBA/excel-add-in-create.htm

Mike

 

[muddan madhu]

check it here

http://www.bettersolutions.com/excel/EIK284/NO418618333.htm