Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Buttons
I have recorded a macro and I want to create a button and link to the macro.
I don't want to add the button to an existing toolbar. I want the button to be located in the body of the worksheet. How do I create the button, move it where I want it on the worksheet, and edit the name to something that is meaningful to the user (i.e., instead of "button17")? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Buttons
Do you have the rectangle button on your toolbar. It looks like a box.
If so, click on it and drag to wherever desiredright click it and you can assign a macro and format it. -- Don Guillett Microsoft MVP Excel SalesAid Software "WVR" wrote in message ... I have recorded a macro and I want to create a button and link to the macro. I don't want to add the button to an existing toolbar. I want the button to be located in the body of the worksheet. How do I create the button, move it where I want it on the worksheet, and edit the name to something that is meaningful to the user (i.e., instead of "button17")? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Buttons
ViewToolbarsForms
Select the button drawing tool(second down on right side) Draw a button, edit the text then right-click and "Assign Macro". Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 15:21:02 -0700, WVR wrote: I have recorded a macro and I want to create a button and link to the macro. I don't want to add the button to an existing toolbar. I want the button to be located in the body of the worksheet. How do I create the button, move it where I want it on the worksheet, and edit the name to something that is meaningful to the user (i.e., instead of "button17")? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Buttons
Why a button?
You can assign a macro to any inserted picture. -- Greetings from New Zealand "WVR" wrote in message ... I have recorded a macro and I want to create a button and link to the macro. I don't want to add the button to an existing toolbar. I want the button to be located in the body of the worksheet. How do I create the button, move it where I want it on the worksheet, and edit the name to something that is meaningful to the user (i.e., instead of "button17")? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Buttons
Or a piece of wordart or any other object you might think of.
Many in Autoshapes on the drawing toolbar to start with. Gord On Thu, 11 Jun 2009 09:19:38 +1200, "Bill Kuunders" wrote: Why a button? You can assign a macro to any inserted picture. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro buttons opening saved macro | Excel Discussion (Misc queries) | |||
Macro Buttons | Excel Worksheet Functions | |||
MACRO BUTTONS | New Users to Excel | |||
Macro Buttons | Excel Discussion (Misc queries) | |||
look for buttons in a macro | Excel Discussion (Misc queries) |