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

--

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

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

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