Public Function Not Showing Up in Spreadsheet

[PJ11]

Hi all,

I am pretty new to VBA and am having a problem that is driving me crazy with a public function that I tried to create.

I have a spreadsheet that has several custom public functions (some created by me, some created by other authors). The problem that I am having is that one of the public functions is not showing up when I start to type it in the spreadsheet (i.e., it is not showing up like =sum, or =product are). All the other functions that were created are showing up fine.

The other weird thing about this though, is that I also made another function that references the "missing" function in the VBA. This new function works fine, and seems to be using the "missing" function fine as well.

Is there something that I am missing? I feel like there must be a simple solution to this problem. Below is the code for the "missing" function.

Public Function StrtWeir(Length As Double, flow As Double) As Double
       StrtWeir = ((flow) / (2.152 * Length)) ^ (2 / 3)
End Function

Thanks for any help and let me know if you need anymore information.