user defined function
 

When calling a user defined function on a worksheet its not found unless I
enter the full path ex) PersonalXL.labor (X,Y,Z). How can I eliminate the
need to include the source workbook path .
Public Function labor (Month, Percentage,Heads as Integer)
Code etc........

End Function

user defined function
 

I store macros and UDF's in an add-in rather than Personal.xls

The prefacing with the filename is then not necessary and you would just enter

=Function labor(x,y,z)

You can turn your Personal.xls into an Add-in by saving as an add-in.

If you prefer to keep Personal.xls as a workbook, open a new workbook, copy the
macros and UDF's you want to a module(s) then FileSave AsFile
TypeAdd-in(*.xla)

Load through ToolsAdd-ins


Gord Dibben MS Excel MVP


On Fri, 30 Nov 2007 16:52:00 -0800, Pete_T
wrote:

When calling a user defined function on a worksheet its not found unless I
enter the full path ex) PersonalXL.labor (X,Y,Z). How can I eliminate the
need to include the source workbook path .
Public Function labor (Month, Percentage,Heads as Integer)
Code etc........

End Function