Forum Discussion
Saving my function to PERSONAL workbook.
Jaqi-
You need to store the Function in your Personal Workbook. Should look something like this:
PERSONAL is already showing. I even had focus on PERSONAL when I created the function. It still saved in the other workbook. I've tried closing that workbook so PERSONAL is the only open workbook and saving it then, but it's not moving it to PERSONAL. There doesn't seem to be a "save as" option for the VBA editor.
Can you take a couple of screenshots so I can help diagnose your issue:
1. Function Code
2. VBE Code Module you are storing the function (With Project Explorer and Header Visible)
3. Developer > Macros > (Screenshot of Pop Up)
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.
