Calling Procedures

J

jrh

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
Click to expand...
something different so they are called by that one
procedure but are not choices to run on their own?

thank you.
 
C

Chip Pearson

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
 
Top