prevent automatic execution of a macro

[macrofan]

I have a command button which is assigned to a macro for a click. However, whenever I open the workbook this macro is automatically executed. But this is not what I want. I want this macro to run only when I click the button. How can I prevent the automatic execution when I open Excel?

Thanks.

 

[Ruddles]

And the MsgBox thing? Did you try that?