Excel 2002 User-Defined Functions

[FractalWalk]

I can't get Excel 2002 to recognize any user-defined functions. Instead, I get the #NAME? error in the cells that reference the function. I placed the following code in a module and it worked fine in Excel 2000.

Function SHEETOFFSET(x, Ref)
Application.Volatile
With Application.Caller.Parent
SHEETOFFSET = .Parent.Sheets(x).Range(Ref.Address).Value
End With
End Function


I even tried the example in the help file (below) and it doesn't work either.

Function Celsius(fDegrees)
Celsius = (fDegrees - 32) * 5 / 9
End Function

 

[FractalWalk]

Never mind. It was a security issue. I had reset the security to allow "unsigned macros" to run but I had to close and re-open before the workbook before it would take.