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

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

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

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

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

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

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

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