I had the same issue. Then I realized that my Sub is stated as private:

Private Sub subname()
So if you want it being visible in the macro dialog box, just remove "Private", but be sure your code still works.