View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Calling Procedures

One way is to declare the procedure as Private. E.g.,

Private Sub TheSubName()
' your code here
End Sub

The disadvantage of this is that the procedure can be called only
by procedures in the same module.

Another way is to make the procedure a Function instead of a Sub
procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"jrh" wrote in message
...
I have a title for a procedure which is the title I want
someone to see when they go to Tools-Macro and pick a
macro to run. This procedure calls a couple of procedures
written below it in the module. I don't want these
procedure names to be choices when someone goes to Tools-
Macro. Do I have to name these other procedures

something different so they are called by that one
procedure but are not choices to run on their own?

thank you.