Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
flycast
 
Posts: n/a
Default Default User Defined Functions - How?

I have some user defined functions that I use quite often. I want to have all
my user defined functions accessable by any workbook that I start at any
time. I do not want to have to open a module that contains the functions and
copy and paste then inside the new workbook.

How con I make all my user defined functions show up in the user defined
function section by default?

Thanks,
Eric
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Save them as *.xla (save asadd-in), then check them under toolsadd-ins

Regards,

Peo sjoblom

"flycast" wrote:

I have some user defined functions that I use quite often. I want to have all
my user defined functions accessable by any workbook that I start at any
time. I do not want to have to open a module that contains the functions and
copy and paste then inside the new workbook.

How con I make all my user defined functions show up in the user defined
function section by default?

Thanks,
Eric

  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

Store them in your personal.xls workbook, typically located in
C:\Program Files\Microsoft Office\Office\XLStart and make this
workbook hidden.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"flycast" wrote in message
...
I have some user defined functions that I use quite often. I
want to have all
my user defined functions accessable by any workbook that I
start at any
time. I do not want to have to open a module that contains the
functions and
copy and paste then inside the new workbook.

How con I make all my user defined functions show up in the
user defined
function section by default?

Thanks,
Eric



  #4   Report Post  
flycast
 
Posts: n/a
Default

Thanks for the reply...both of you.

Follow up question...
I I use one method or the other. Say I create a workbook that uses some of
the formulas and then send that workbook to a coworker, will my formulas go
with it or will it end up displaying a #name error?

Thanks,
Eric
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

If they don't have the addin, then they'll get errors.


flycast wrote:

Thanks for the reply...both of you.

Follow up question...
I I use one method or the other. Say I create a workbook that uses some of
the formulas and then send that workbook to a coworker, will my formulas go
with it or will it end up displaying a #name error?

Thanks,
Eric


--

Dave Peterson
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
User Defined Functions Jeff B Excel Worksheet Functions 1 April 27th 05 09:59 PM
User Defined Functions Frank@shell Excel Worksheet Functions 3 April 20th 05 02:41 PM
I have user defined functions in sprdsheet. I want to put sprdsh. hjyoungii Excel Worksheet Functions 4 April 1st 05 10:48 PM
Excel user defined functions. Matt Excel Worksheet Functions 4 March 15th 05 08:22 PM
User defined charts- font size too small Bill B Charts and Charting in Excel 1 December 30th 04 07:23 PM


All times are GMT +1. The time now is 07:23 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"