Created a function, for the personal.xlsb file

[hitbid]

I just started creating some functions, not sure why I ignored this functionality but they are really handy.

I had a very simple one I figured I would just port over to the personal workbook and be able to use, but it seems functions are not as functional as macros, in that I can't access the function outside of the workbook it is located in.

Is there a way around this? How do you access a function in your personal workbook?

 

[Dave Patton]

Excel 2010
	A	B	C
2		105.00	5.00
3
4	My file	T10_1807a	1b
5
1b

Cell Formulas
Range	Formula
C2	=Personal.xlsb!Gste(B2)

With the UDF stored in Personal.xlsb
In order to use the function you have to precede the function name with PERSONAL.XLSB!

 

[hitbid]

Ha, so it does! Thanks Dave.

 

[My Aswer Is This]

Excel 2010

	A	B	C
2		105.00	5.00
3
4	My file	T10_1807a	1b
5

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

1b​

Worksheet Formulas Cell Formula C2 =Personal.xlsb!Gste(B2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

With the UDF stored in Personal.xlsb
In order to use the function you have to precede the function name with PERSONAL.XLSB!

I never have to do it that way. I just enter =something() And yes the function is in my Personal Workbook only