Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How to use User-defined-functions in other workbooks?

How to use User-defined-functions in other workbooks other
than saved "xla" files.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How to use User-defined-functions in other workbooks?

=Personal.xls!Myfunction(arg1,arg2)
the workbook with the UDF must be open.

Or copy the UDF to the workbook where you want to use it.

--
Regards,
Tom Ogilvy

"JohnDing" wrote in message
...
How to use User-defined-functions in other workbooks other
than saved "xla" files.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default How to use User-defined-functions in other workbooks?

On Wed, 15 Sep 2004 01:39:43 -0700, "JohnDing"
wrote:

How to use User-defined-functions in other workbooks other
than saved "xla" files.


Put it in your personal.xls file


--ron
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
Macros and user-defined functions used in several workbooks Bruno Excel Discussion (Misc queries) 0 April 1st 09 05:44 PM
Making User defined functions available in all new workbooks Alco Engineer[_2_] Excel Worksheet Functions 5 March 10th 09 10:15 PM
User Defined Functions Jeff B Excel Worksheet Functions 1 April 27th 05 09:59 PM
user defined functions Alexander Bogomolny Excel Programming 4 July 25th 04 07:54 PM
excel functions and User defined functions Kanan Excel Programming 4 May 20th 04 11:21 PM


All times are GMT +1. The time now is 08:33 PM.

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

About Us

"It's about Microsoft Excel"