Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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....
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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....

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 747
Default 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....


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel User Defined Functions + Link.How to stop #Value after save DaveH Excel Discussion (Misc queries) 2 July 14th 07 01:17 AM
User defined functions without using VBA. [email protected] Excel Worksheet Functions 0 June 13th 06 05:49 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
I have had difficulty in creating user defined functions in Excel MichaelG Excel Worksheet Functions 3 July 13th 05 11:59 AM
Excel user defined functions. Matt Excel Worksheet Functions 4 March 15th 05 07:22 PM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"