My apologies if this is already asked and answered but I could not find a solution after hours of searching. I have an excel workbook with a number of functions and subroutines written in VBA. I had problems with one and got them fixed. Everything worked fine in all of the cells in which the function was called. The program changed the name to all caps indicating that it was happy with the function. My problem is that when I save, exit and then reload the program and the file, I get #NAME errors on all of the referencing cells and the function name is shown in all lower case. It is my understanding that the change to all lower case indicates a problem with the function. Given that it worked before saving and exiting, I am lost as to why it is a problem now,
Then the functions
- are not present in the document
- are not in the Standard directory (other directories will not be loaded automatically into the system memory in the LO Calc application )
Please upload a sample document here (with the embedded macro code)