can't see macro moved from workbook into personal.xlsb

can't see macro moved from workbook into personal.xlsb

I am using W10 and excel 365 home subscription

I created an excel vba module in a workbook, A, and tested it out using debug.

The module consists of a private subroutine that tests out a custom public function.

While the code works just fine in the VBE environment, I do not know how to make the worksheet in which the module is in "see" the custom function. How do I do that?


Secondly, I want to move the module into personal.xlsb as I could use this code in other worksheets once i learn how to make the worksheet see the macro.


I created the personal.xlsb (as i did not have one) by creating a null macro.

I can see the personal.xlsb in my Project VBA editor within workbook A

So...I left clicked and dragged the module from A into the Personal.xlsb
folder under the modules folder.

But if i get out of the VBA editor and go to the excel spreadsheet and
click on "macro" in the code section of the developer ribbon, I do not see the vba macro when I click on the drop down list box and select macros in Personal.xlsb

I must be doing something incorrectly. any ideas?