User Defined Functions: Where do I go to to find the "code"

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" <Frankshell@discussions.microsoft.com> wrote in message
news:A7D1B81C-66E4-4E03-871E-0B5270CA6F64@microsoft.com...
> 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" <Frankshell@discussions.microsoft.com> wrote in message
news:A7D1B81C-66E4-4E03-871E-0B5270CA6F64@microsoft.com...
> 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" <Frankshell@discussions.microsoft.com> wrote in message
news:A7D1B81C-66E4-4E03-871E-0B5270CA6F64@microsoft.com...
>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