VBA 関数から関数を呼び出す

Quick Edit Pencil
Call　や　Application.Run　で 

Private Sub CommandButton1_Click()

Call Module4.test4
'Application.Run "'" & ActiveWorkbook.Path & "\" & ActiveWorkbook.Name & "'!Module4.test4"

End Sub