Thread: recorded macros
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default recorded macros

Your welcome

"Jemma" wrote:

Thank you very much!

"Mike H" wrote:

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" wrote:

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