@Rajesh Kumar Sahoo I think you should use something like this (using the code example above):

Public Sub SayHello(ByVal name As String)
    Call YourMacroName
End Sub