Can't a UDF be set in personal.xlsb? I have found only sub-routines to be working in the same.
F Faraz A. Qureshi Sep 29, 2009 #1 Can't a UDF be set in personal.xlsb? I have found only sub-routines to be working in the same.
J Jacob Skaria Sep 29, 2009 #2 xlsm right? If the UDF name is 'GetmyFunction' with an argument; try =personal.xlsm!GetmyFunction(A1) If this post helps click Yes
xlsm right? If the UDF name is 'GetmyFunction' with an argument; try =personal.xlsm!GetmyFunction(A1) If this post helps click Yes
F Faraz A. Qureshi Sep 29, 2009 #3 Hi there Jacob! I am sorry but I don't understand. The personal macro book is PERSONAL.xlsb isn't it? I have tried to copy some of my UDFs to the same.
Hi there Jacob! I am sorry but I don't understand. The personal macro book is PERSONAL.xlsb isn't it? I have tried to copy some of my UDFs to the same.
J Jacob Skaria Sep 29, 2009 #4 You need to preface the UDF with Personal.xlsb in order to call that UDF from Personal.xlsb. =Personal.xlsb!MyUDF(arguments) If this post helps click Yes
You need to preface the UDF with Personal.xlsb in order to call that UDF from Personal.xlsb. =Personal.xlsb!MyUDF(arguments) If this post helps click Yes
R Ron de Bruin Sep 29, 2009 #5 See also http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm
See also http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm
