I use Excel 2002
I run many VBA procedures - all sub procedures in fact - for my business. Because I need certainty of backup, and cannot control multiple versions of the same code, I place all these into general modules in Personal.xls. My Security is set to Low, and all the VBA procedures work from whichever spreadsheet I call them.
I need to start working with User Defined Functions. I have used a one line textbook Fahrenheit to Centigrade Function as a tester.
CtoF = Centigrade * 9 / 5 + 32
By experimentation I have discovered that I can only get this Function to work if I place it in a general module in the particular spreadsheet from which I am calling it.
I have not yet been able to get this or any other Function to work if it is placed in Personal.xls. I have tried calling it a Public Function, but have seen no difference in result - which is always the #Name error with the message saying that the function name is unrecognised text.
Could anyone guide me to a way of getting a UD Function to work in any spreadsheet by calling it only from a module in Personal.xls?