ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to add user defined functions in excel permanantly (https://www.excelbanter.com/excel-discussion-misc-queries/205788-how-add-user-defined-functions-excel-permanantly.html)

Sandeep Jangra

How to add user defined functions in excel permanantly
 
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

How to add user defined functions in excel permanantly
 
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

"Sandeep Jangra" wrote:

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....


muddan madhu

How to add user defined functions in excel permanantly
 
check it here

http://www.bettersolutions.com/excel...O418618333.htm


On Oct 10, 12:18*pm, Sandeep Jangra <Sandeep
wrote:
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....




All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com