How to create a command button

  • Thread starter Thread starter diepvic
  • Start date Start date
D

diepvic

Hi,
I've just finished writing a macro. Can any body advise me how to create a
button for the macro so that we can click the button to run that macro.

Thanks a lot
 
--From Toolbars>DrawingToolbar>AutoShapes>Basic Shapes select any shape you
like. say ("Bevel") and place that in your worksheet.

--Right click the shape>Assign Macro> and select the macro to be assigned

If this post helps click Yes
 
Back
Top