title: Click CommandButton in an other Worksheet by clicking another Command Button
body: <p>I have several commandbuttons in different sheet. Now I want the user to be able to run all at once if wanted. Therefore I want to use a new CommandButton that runs all CommandButtons in all Worksheets. However I allways get a error message..I have to approaches and have not worked out for me:</p>
  
  <p>running the subs:</p>
  
  <pre><code>Private Sub CommandButtonX_Click()
  
  
  run CommandButtonY_Click
  
  run CommandButtonZ_Click
  
  etc.
  
  end sub
  </code></pre>
  
  <p>..Nothing happens</p>
  
  <p>My other Approach is to select all worksheets and "activate the commmand button", which is always called CommandButton1_Click however I still don´t know how to do it</p>
  
  <p>This was my approach:</p>
  
  <pre><code>Sheets(Array("AA", "BB", "CC",etc.).Select
      Sheets("AA").ActivateCall 
  
  Call CommandButton1_Click
  
  End Sub
  </code></pre>
  
  <p>I am new at this, so I would really apreciate your Help!</p>
  
  <p>Thanks!</p>
  
  <p>Jens</p>