You appeared to be directing your follow-up question to JoeM, but perhaps he isn't around. I read the response that suggested calling the code from a macro as his interpretation of what you wanted to do: "You want to run the VBA code you come up with from a Macro".
If that's not the case, you're certainly correct that calling it directly from VBA would be better than using a macro. Giving the function a different name than the macro isn't required, but it would avoid potential confusion.
Regarding "where is the source for Function MyCode()? In the navigation pane?", you would see the module the function is contained in, not the function itself. They can't have the same name.