UDF in personal.xlsb is not recognized

[David]

I wrote a User Definied Function and saved it in Module1 in Personal.xlsb
but it works only from the Immediate window and only if the "personal.xlsb"
project is selected in the project window in VBE.
All tutorials in internet say that saving the function in any module in
personal.xlsb is enough to have it available in any worksheet.
Why it doesn't work?
Please help.

TIA
David

 

[Claus Busch]

Hi David,

Am Thu, 29 Nov 2012 19:36:52 +0100 schrieb David:

I wrote a User Definied Function and saved it in Module1 in Personal.xlsb
but it works only from the Immediate window and only if the "personal.xlsb"
project is selected in the project window in VBE.
All tutorials in internet say that saving the function in any module in
personal.xlsb is enough to have it available in any worksheet.

in front of your function you have do write PERSONAL.xlsb!
e.g.: =PERSONAL.XLSB!mysum()


Regards
Claus Busch

 

[David]

Il Thu, 29 Nov 2012 19:44:50 +0100, Claus Busch ha scritto:

Hi David,

Am Thu, 29 Nov 2012 19:36:52 +0100 schrieb David:


in front of your function you have do write PERSONAL.xlsb!
e.g.: =PERSONAL.XLSB!mysum()

It works, thank you.

David

 

[Gord Dibben]

David

I prefer to place all my commonly-used macros in an
add-in.............you don't have to use the filename prefix.

=mysum() will suffice


Gord