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
---------------
Jacob Skaria


"diepvic" wrote:

> 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

Take a look at this:
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacob Skaria" wrote:

> --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
> ---------------
> Jacob Skaria
>
>
> "diepvic" wrote:
>
> > 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

Thx so much Jacob