Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frank@shell
 
Posts: n/a
Default User Defined Functions

I have inherited a spreadsheet with user defined functions. (e.g.
"=StatLib_CalcMeanLnDist(AL15,AL16)").

Where do I go to to find the "code" behind this function?

Any help will be greatly appreciated.

Frank
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frank@shell" wrote in message
...
I have inherited a spreadsheet with user defined functions. (e.g.
"=StatLib_CalcMeanLnDist(AL15,AL16)").

Where do I go to to find the "code" behind this function?

Any help will be greatly appreciated.

Frank



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

In the VBA.

Hit Alt-F11, select the workbook from the explorer window, and open the code
modules in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frank@shell" wrote in message
...
I have inherited a spreadsheet with user defined functions. (e.g.
"=StatLib_CalcMeanLnDist(AL15,AL16)").

Where do I go to to find the "code" behind this function?

Any help will be greatly appreciated.

Frank



  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Press Alt + F11 to open the VBE and look in the project pane to the left, of
course if it is password protected you can't see the code

--
Regards,

Peo Sjoblom


"Frank@shell" wrote in message
...
I have inherited a spreadsheet with user defined functions. (e.g.
"=StatLib_CalcMeanLnDist(AL15,AL16)").

Where do I go to to find the "code" behind this function?

Any help will be greatly appreciated.

Frank



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
I have user defined functions in sprdsheet. I want to put sprdsh. hjyoungii Excel Worksheet Functions 4 April 1st 05 10:48 PM
Format a cell with numbers and user defined text Rod R. Excel Discussion (Misc queries) 0 March 30th 05 04:31 PM
Excel user defined functions. Matt Excel Worksheet Functions 4 March 15th 05 08:22 PM
user defined function row number bj Excel Worksheet Functions 11 March 9th 05 02:31 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 06:45 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"