Prev: Pivot table to calculate variance showing budget and actual.
Next: COUNTIF Function
From: Diego Miranda Diego on 19 Apr 2010 13:48
I have created some customized functions no the PERSONAL.XLSB file but I
cannot use them in any other workbook i use. I have plenty macros on this
PERSONAL file and they all work well everywhere, but i dont see to find how
to make the functions work in the same way.

Is it possible to do this?

Thank you.
From: Duke Carey on 19 Apr 2010 14:57
click on the Fx symbol to the left of the formula bar. In the pop up use the
Category selector to choose User-defined. You'll find your functions there

"Diego Miranda" wrote:

> I have created some customized functions no the PERSONAL.XLSB file but I
> cannot use them in any other workbook i use. I have plenty macros on this
> PERSONAL file and they all work well everywhere, but i dont see to find how
> to make the functions work in the same way.
>
> Is it possible to do this?
>
> Thank you.
From: T. Valko on 19 Apr 2010 17:11
You have to include the name of the file that contains the function...

=PERSONAL.XLSB!Your_Function_Here()

--
Biff
Microsoft Excel MVP


"Diego Miranda" <Diego Miranda(a)discussions.microsoft.com> wrote in message
news:23E55330-BE21-48E8-B6C7-76E0D66C5725(a)microsoft.com...
>I have created some customized functions no the PERSONAL.XLSB file but I
> cannot use them in any other workbook i use. I have plenty macros on this
> PERSONAL file and they all work well everywhere, but i dont see to find
> how
> to make the functions work in the same way.
>
> Is it possible to do this?
>
> Thank you.


 | 
Pages: 1
Prev: Pivot table to calculate variance showing budget and actual.
Next: COUNTIF Function