| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
recorded macros
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
recorded macros
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
recorded macros
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recorded macro | Excel Discussion (Misc queries) | |||
| Repeat a recorded macro | Excel Discussion (Misc queries) | |||
| How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
| Recorded Macro | New Users to Excel | |||
| I recorded a macro, how can i share it with others? | Excel Worksheet Functions | |||
Linear Mode
