View Single Post
  #7   Report Post  
Harald Staff
 
Posts: n/a
Default 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