title: Can you a call a Sub that has an argument with a button?
body: <p>I want to call the following sub with a button from my excel sheet but it doesn't appear in the list when you try to assign a macro. I also call it from a bigger macro, in which case I don't want to show the "Finished" message box. Hence I have the DontShowMsgBox boolean argument.</p>
  
  <pre><code>Sub InteriorDumbCopyExport(DontShowMsgBox as Boolean)
  
  'do stuff...
  
  If DontShowMsgBox Then
      MsgBox "Finished."
  End If
  
  End Sub
  </code></pre>
  
  <p>It's when I add the argument in that I can no longer see it in the list. Is there an easy way around this? </p>
  
  <p>I want to call the sub directly as I have to call it from a shape so can't use an ActiveX button. I haven't found anything in my searching so far but feel there must be a solution, otherwise what is the difference between a function with an argument and a sub with an argument?</p>