How to call a Private Sub

[ardanni90]

So I am trying to create a master macro that will open up different worbooks and run the macros within them.

One of the sheets contains a macro that uses a private sub --> Private Sub CommandButton1_Click()

The code that I am using to call these macros is....Application.Run ("'AP&AR Impulse2 (BUFFALO).xlsm'!start"). With "start" being where I enter the marco name. However when I enter "CommandButton1_Click()" I get the error that says this macro does not exist.

Could anyone help with this??

Thanks!

 

[Joe4]

If you make the Procedure "Private", it cannot be seen from outside the Module it exists in.
Check out "Procedures and Access Levels" here: VBA For Microsoft Excel - Lesson 05: Introduction to Procedures