Forum Discussion
Saving my function to PERSONAL workbook.
Jaqi-
You need to store the Function in your Personal Workbook. Should look something like this:
Jaqi-
You need to access the Personal Workbook to be able to store macros in it. Sometimes it can be a little elusive.
Try doing the following steps to complete your task:
1. Open a new Excel File
2. Click Record Macro (On the Developer tab)
3. Select Store in Personal Macro Workbook
4. Click OK
5. Click Stop Recording
6. Click Visual Basic (Far Left on Developer tab)
7. Once in the Visual Basic Editor (VBE), Click on the project labeled VBAProject(Personal.XLSB)
8. Click on Module 1
9. Where the current macro code is delete it all
10. Paste your function code
11. Click the save icon in the VBE
12. Your function is now available in all workbooks
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:
