Personal workbook

johnpgalla1 · May 19th, 2002, 06:13 PM

I have created a function in my personal workbook. I thought the function would be available to a new workbook. The function only works in the personal workbook. Is there a way I can make this function available to other workbooks without recreating the fuction in each workbook?

Thanks for the help

Tommy Bak · May 19th, 2002, 06:44 PM

Hi
It should be available to you.
in Fx (the function list) it is under userdefined.
Else it can be referenced like this
=personal.xls!testfunction()
regards Tommy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 06:13 PM	#1
johnpgalla1 New Member Join Date: May 2002 Posts: 1	I have created a function in my personal workbook. I thought the function would be available to a new workbook. The function only works in the personal workbook. Is there a way I can make this function available to other workbooks without recreating the fuction in each workbook? Thanks for the help

May 19th, 2002, 06:44 PM	#2
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	Hi It should be available to you. in Fx (the function list) it is under userdefined. Else it can be referenced like this =personal.xls!testfunction() regards Tommy