<div>
BTW - you will also still be able to call them as you have been.
</div>


BTW - you will also still be able to call them as you have been.

<div>
Wayne's method will work easily for you and he deserves the points, but another way would be to put &quot;Private &quot;&nbsp;before Sub, assuming macros 1-5 are in the same module as FinalMacro.<br />
Though I would change his &quot;Str&quot; variable to a random name, as Str is a VB function :)<br />
Matt
</div>


Wayne's method will work easily for you and he deserves the points, but another way would be to put "Private " before Sub, assuming macros 1-5 are in the same module as FinalMacro.
Though I would change his "Str" variable to a random name, as Str is a VB function :)
Matt

<div>
<div class="content wysiwyg-content">
If I have 5 macros, and then have one master macro that runs the other five, can I hide the five from the end user? <br />
<br />
Example<br />
<br />
Macro1<br />
Macro2<br />
Macro3<br />
Macro4<br />
Macro5<br />
FinalMacro<br />
<br />
FinalMacro runs Macros 1 through 5 in order. I want the user to only see FinalMacro, is this possible?
</div>
</div>


If I have 5 macros, and then have one master macro that runs the other five, can I hide the five from the end user? 

Example

Macro1
Macro2
Macro3
Macro4
Macro5
FinalMacro

FinalMacro runs Macros 1 through 5 in order. I want the user to only see FinalMacro, is this possible?

Hide macros?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.