Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
How do I place a single "button" on a worksheet (say, in one cell), and
assign a macro to it? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
Hi,
Choose View, Toolbars, and pick the Forms toolbar. Click the Button tool and then click in the spreadsheet. You will be prompted for the macro you want to assign. You can resize and move the button after assigning the macro. If this helps, please click the Yes button Cheers, Shane Devenshire "PFB" wrote: How do I place a single "button" on a worksheet (say, in one cell), and assign a macro to it? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
I often use shapes from the drawing tool bar. OR, even pictures. -- Don Guillett Microsoft MVP Excel SalesAid Software "Shane Devenshire" wrote in message ... Hi, Choose View, Toolbars, and pick the Forms toolbar. Click the Button tool and then click in the spreadsheet. You will be prompted for the macro you want to assign. You can resize and move the button after assigning the macro. If this helps, please click the Yes button Cheers, Shane Devenshire "PFB" wrote: How do I place a single "button" on a worksheet (say, in one cell), and assign a macro to it? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
Hi,
Sounds simple, but I am using Excel2007 (Vista) and I can't find "Toolbars" or "Forms" on the ribbon under View, and the help function has not "helped". What am I missing? Thanks, Paul "Shane Devenshire" wrote: Hi, Choose View, Toolbars, and pick the Forms toolbar. Click the Button tool and then click in the spreadsheet. You will be prompted for the macro you want to assign. You can resize and move the button after assigning the macro. If this helps, please click the Yes button Cheers, Shane Devenshire "PFB" wrote: How do I place a single "button" on a worksheet (say, in one cell), and assign a macro to it? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
You have to show the Developer tab
I _think_ it's under Office button|excel options|Popular Then click on the Developer tab|Controls Group|Insert icon You'll be able to choose between a button from the Forms toolbar (on top) or a commandbutton from the control toolbox toolbar (on the bottom). You want the top one. PFB wrote: Hi, Sounds simple, but I am using Excel2007 (Vista) and I can't find "Toolbars" or "Forms" on the ribbon under View, and the help function has not "helped". What am I missing? Thanks, Paul "Shane Devenshire" wrote: Hi, Choose View, Toolbars, and pick the Forms toolbar. Click the Button tool and then click in the spreadsheet. You will be prompted for the macro you want to assign. You can resize and move the button after assigning the macro. If this helps, please click the Yes button Cheers, Shane Devenshire "PFB" wrote: How do I place a single "button" on a worksheet (say, in one cell), and assign a macro to it? -- Dave Peterson |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
On Dec 1, 3:10*am, Shane Devenshire
wrote: Hi, Choose View, Toolbars, and pick the Forms toolbar. *Click the Button tool and then click in the spreadsheet. *You will be prompted for the macro you want to assign. *You can resize andmovethe button after assigning the macro. If this helps, please click the Yes button Cheers, Shane Devenshire "PFB" wrote: How do I place a single "button" on aworksheet(say, in one cell), and assign a macro to it?- Hide quoted text - - Show quoted text - How do I move the button and macro? When I move the button, the macro stays in place it was created. I would like to add rows to my worksheet, but when I do all of my macros are askew. Thanks, Kasandra |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Place a button on a worksheet and assign a macro to it?
The macro stays assigned to the button no matter where you move it.
If your macro relies on the position of the button, you could check in your code. For instance: Option Explicit sub testme() dim BTN as button 'from the Forms toolbar! set btn = activesheet.buttons(application.caller) msgbox btn.topleftcell.address 'just to show you. 'select the row that contains the topleftcell of the button btn.topleftcell.entirerow.select end sub wrote: <<snipped How do I move the button and macro? When I move the button, the macro stays in place it was created. I would like to add rows to my worksheet, but when I do all of my macros are askew. Thanks, Kasandra -- Dave Peterson |
#8
|
|||
|
|||
Quote:
regards mjd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a macro to a button | Excel Discussion (Misc queries) | |||
Assign a macro to a command button | Excel Discussion (Misc queries) | |||
How do I Assign Macro to a button? | Charts and Charting in Excel | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
assign a macro to a control button | Excel Discussion (Misc queries) |