I forgot to put "Optional" in. :-(
For the following .........
Option Explicit
Sub subMain()
subOptP1AsString
End Sub
' ------------------------------------
Sub subOptP1(Optional p1)
End Sub
' ------------------------------------
Sub subOptP1AsVariant(Optional p1 As Variant)
End Sub
' ------------------------------------
Sub subOptP1AsString(Optional p1 As String)
MsgBox "\"
End Sub
........... When I look at Tools/Macros..
subMain
subOptP1
subOptP1AsVariant
.......... All show up
But subOptP1AsString don't!
Curious don't you think.