UDF returns #NAME?

[wadevcamp]

UDFs in PERSONAL.XLSB are not being recognized. I put the following VBA code into PERSONAL.XLSB and in the spreadsheet entered "=prnt(2)", and the result is #NAME?". I then created a VBA module within the open spreadsheet, copied the code into it, and it works just fine.

The PERSONAL.XLSB file is trusted, and is not a disabled add-in.

PLEASE HELP!

Function PRNT(i As Integer)
'
PRNT = i + 1

End Function

Sub test()
i = PRNT(3)
MsgBox ("result is " & i)
End Sub

 

[Fluff]

You need to use

=personal.xlsb!prnt(2)

 

[wadevcamp]

Is there a way to tell my workbook to include personal.xlsb in the references it checks automatically (instead of brute forcing it by telling it the name of the workbook to check???

 

[Fluff]

Not that I'm aware of, unless you turn it into an add-in.