I just created a simple macro to run in one of my workbooks. When I enter
visual basic and click Run Sub/User Form, the macro works fine. However,
when I create a command button, type the name of the macro in the code for
the button, and then push the button, I get a Compile Error:Argument Not
Optional. I have several other command buttons in this workbook that work
fine. Is there any way to fix this? It's kind of a pain to have to go into
visual basic and click run instead of just clicking a button.

Thanks

Adam Bush