recorded macros

  • Thread starter Thread starter Jemma
  • Start date Start date
J

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
 
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
 
Thank you very much!

Mike H said:
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
Click to expand...
 
Back
Top