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

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
donaldb@281.com
"nathan" <nathan@discussions.microsoft.com> wrote in message
news:3EF2F062-09C3-43F6-86AE-8F1F97F4D4E5@microsoft.com...
> 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
donaldb@281.com
"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:6DBBA0D3-2102-4A19-871B-C7520EB03EDB@microsoft.com...
> 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
> donaldb@281.com
> "nathan" <nathan@discussions.microsoft.com> wrote in message
> news:3EF2F062-09C3-43F6-86AE-8F1F97F4D4E5@microsoft.com...
> > 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" <nathan@discussions.microsoft.com> skrev i melding
news:3EF2F062-09C3-43F6-86AE-8F1F97F4D4E5@microsoft.com...
> 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
gary_brown@ge_NOSPAM.com
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