Design/run modes for a button
 

How do you switch between desing and run mode of a button that runs a macro?

You can originate a command button from two places: the Controls
Toolbox toolbar and the Forms toolbar. I most frequently use the
button from the Forms toolbar, since I typically install a button
directly within a worksheet and assign a macro to it. Your choice of
buttons depends on your intent: what is your end goal?