Private Function <your name> () ‘your code here ‘callable only by procedures in the same module End Function Public Function <your name> () ‘callable from any procedure End Function Private Sub <your name> () ‘callable only by procedures in the same module ‘cannot be called from Macros dialog box End Sub Public Sub <your name> () ‘callable from any procedure of any module ‘can run procedure from Macros dialog box End Sub
Advertisements