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