recorded macros

[Jemma]

Hi i have recorded a macro to clear the contents of selected cells within my
worksheet but i would like to create a clear button to do this instead, but
how? Thanks

 

[Mike H]

Hi,

I assume you mean you want a button to run yoyr recorded macro.

View|Toolbars|Forms
Click the button icon on the toolbar
On the worksheet left click and drag to get the button size you want.
Release the left button and in the popup that appears navigate to your macro
name and click OK.

Mike

 

[Jemma]

Thank you very much!

Hi,

I assume you mean you want a button to run yoyr recorded macro.

View|Toolbars|Forms
Click the button icon on the toolbar
On the worksheet left click and drag to get the button size you want.
Release the left button and in the popup that appears navigate to your macro
name and click OK.

Mike

 

[Mike H]

Your welcome

Thank you very much!