Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
-- 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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have user defined functions in sprdsheet. I want to put sprdsh. | Excel Worksheet Functions | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
Excel user defined functions. | Excel Worksheet Functions | |||
user defined function row number | Excel Worksheet Functions | |||
User defined charts- font size too small | Charts and Charting in Excel |