can't find custom function code

[Guest]

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

 

[Guest]

Maybe they are in worksheet code. Right click each tab and view code.

 

[Don Guillett]

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

 

[Don Guillett]

wouldn't work there

 

[Guest]

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

 

[Guest]

Thanks for the suggestion. No luck.

Maybe they are in worksheet code. Right click each tab and view code.

 

[Harald Staff]

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

 

[Guest]

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

HTH,