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

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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:

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()


It works, thank you.

David

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

On Thu, 29 Nov 2012 20:11:58 +0100, David wrote:

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:

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()


It works, thank you.

David