can't find custom function code
 

Hello,

I have inherited a former employee's spreadsheet. There are numerous custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

Maybe they are in worksheet code. Right click each tab and view code.
--
Gary''s Student


"nathan" wrote:

Hello,

I have inherited a former employee's spreadsheet. There are numerous custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

have you tried alt f11 and looked in the regular modules within the editor?

--
Don Guillett
SalesAid Software

"nathan" wrote in message
...
Hello,

I have inherited a former employee's spreadsheet. There are numerous
custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to
find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

wouldn't work there

--
Don Guillett
SalesAid Software

"Gary''s Student" wrote in message
...
Maybe they are in worksheet code. Right click each tab and view code.
--
Gary''s Student


"nathan" wrote:

Hello,

I have inherited a former employee's spreadsheet. There are numerous
custom
functions used in it. I cannot seem to find the code for these
functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must
be
located somewhere...possibly hidden somehow or I just don't know how to
find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

Yes I have. There are no modules that contain function modules.

"Don Guillett" wrote:

have you tried alt f11 and looked in the regular modules within the editor?

--
Don Guillett
SalesAid Software

"nathan" wrote in message
...
Hello,

I have inherited a former employee's spreadsheet. There are numerous
custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to
find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

Thanks for the suggestion. No luck.

"Gary''s Student" wrote:

Maybe they are in worksheet code. Right click each tab and view code.
--
Gary''s Student


"nathan" wrote:

Hello,

I have inherited a former employee's spreadsheet. There are numerous custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

Hi Nathan

Mystery code is often Excel4 macros. Try running this and see if a macro
sheet turns up:

Sub ShowAll()
Dim S As Object
For Each S In ActiveWorkbook.Sheets
S.Visible = True
Next
End Sub

HTH. Best wishes Harald

"nathan" skrev i melding
...
Hello,

I have inherited a former employee's spreadsheet. There are numerous
custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to
find
the code.

Any ideas?

Thanks,
Nathan

can't find custom function code
 

Also check out the Microsoft Script Editor...
Alt-Shift-F11

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"nathan" wrote:

Hello,

I have inherited a former employee's spreadsheet. There are numerous custom
functions used in it. I cannot seem to find the code for these functions
anywhere...in a VB module or in a custom add-in (.xla), etc. They must be
located somewhere...possibly hidden somehow or I just don't know how to find
the code.

Any ideas?

Thanks,
Nathan