Forum Discussion
Saving my function to PERSONAL workbook.
Jaqi-
You need to store the Function in your Personal Workbook. Should look something like this:
I'm having trouble figuring out the VBA project navigation. I now can't find where the function was stored. I can use it, but not find where I defined it.
By the way, this is a custom function, not a macro. I can't seem to figure out how custom functions are filed in the VBA navigation pane. I can find my macros through the developer tab, but I can't find any way to access the custom function. I don't even see where I would try to enter another custom function.
Jaqi-
You need to store the Function in your Personal Workbook. Should look something like this:
OK, I found my function and saved it to PERSONAL, and it seems to work. It's a shame I have to include the PERSONAL.XLSB! before the function name, it could be a lot easier to use, but I'm not going to save it in every workbook I want to use it in. Especially since there are so many empty modules already from my poke-and-guess efforts to figure out how this works. There doesn't seem to be a way to delete modules after they are created, is there? This file system is an ugly mess.
Jaqi-
Glad you were able to get your issue resolved. If you remove the VBA Function from the file you're working in it will no longer be necessary to reference the Personal Workbook. I believe that since you have this function in the file you're working with and you're personal workbook Excel needs you to further qualify the reference to identify which one you are trying to use.
You just need the function in the personal workbook. In order to find where the code is your current workbook you can use Ctrl + F and search for the function in the Visual Basic Editor. Once you have found the function in the workbook just delete it. (just be careful not to accidentally remove it from your personal workbook).
Please let me know if you need further assistance. Always happy to help.