Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign a macro to a button
How do I assign a macro to a button in the Quick Access Toolbar. And run the
macro by just cliking the button and not open the macro file first. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign a macro to a button
On Dec 11, 3:50 pm, totofab wrote:
How do I assign a macro to a button in the Quick Access Toolbar. And run the macro by just cliking the button and not open the macro file first. Right click anywhere up on the toolbar menu, go to CUSTOMIZE. In the Customize dialogue box, click the COMMANDS tab. In the list on the left, scroll down to MACROS. Then drag either of the buttons on the right up to your toolbar. Now right click the new button and you'll at the buttom: "Assign Macro...". Click that. you can also set other things like the buttom image, what the button says, etc... enjoy! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign a macro to a button
But I'm using 2007.
"dksaluki" wrote: On Dec 11, 3:50 pm, totofab wrote: How do I assign a macro to a button in the Quick Access Toolbar. And run the macro by just cliking the button and not open the macro file first. Right click anywhere up on the toolbar menu, go to CUSTOMIZE. In the Customize dialogue box, click the COMMANDS tab. In the list on the left, scroll down to MACROS. Then drag either of the buttons on the right up to your toolbar. Now right click the new button and you'll at the buttom: "Assign Macro...". Click that. you can also set other things like the buttom image, what the button says, etc... enjoy! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign a macro to a button
Hi,
officebutton, excel options, customize, dropdown field change from popular commands, to macro. If there is code in your workbook, you will see your macro module listed below. click the add button in the middle to move it to the right side. it is now in the quick access toolbar. if your workbook does not contain any code modules, you will not be able to see anything below the macro button. to change the face image of the button, after you have done the above, there is a modify button near the bottom right. click it and change to the icons shown as desired. totofab wrote: But I'm using 2007. "dksaluki" wrote: On Dec 11, 3:50 pm, totofab wrote: How do I assign a macro to a button in the Quick Access Toolbar. And run the macro by just cliking the button and not open the macro file first. Right click anywhere up on the toolbar menu, go to CUSTOMIZE. In the Customize dialogue box, click the COMMANDS tab. In the list on the left, scroll down to MACROS. Then drag either of the buttons on the right up to your toolbar. Now right click the new button and you'll at the buttom: "Assign Macro...". Click that. you can also set other things like the buttom image, what the button says, etc... enjoy! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign a macro to a button
Did that, however when I click on the macro button I get the message "Cannot
run the macro "(macroName)". The macro may not be available in this workbook or all macros may be disbaled". But I open the macro file (and it has to be the active file) - and click on the button it runs fine. Never had a problem with macro buttons in Excel 2003. Don't know what I'm missing. Any help is appreciated. "ju" wrote: Hi, officebutton, excel options, customize, dropdown field change from popular commands, to macro. If there is code in your workbook, you will see your macro module listed below. click the add button in the middle to move it to the right side. it is now in the quick access toolbar. if your workbook does not contain any code modules, you will not be able to see anything below the macro button. to change the face image of the button, after you have done the above, there is a modify button near the bottom right. click it and change to the icons shown as desired. totofab wrote: But I'm using 2007. "dksaluki" wrote: On Dec 11, 3:50 pm, totofab wrote: How do I assign a macro to a button in the Quick Access Toolbar. And run the macro by just cliking the button and not open the macro file first. Right click anywhere up on the toolbar menu, go to CUSTOMIZE. In the Customize dialogue box, click the COMMANDS tab. In the list on the left, scroll down to MACROS. Then drag either of the buttons on the right up to your toolbar. Now right click the new button and you'll at the buttom: "Assign Macro...". Click that. you can also set other things like the buttom image, what the button says, etc... enjoy! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a macro to a command button | Excel Discussion (Misc queries) | |||
Assign a macro to Command Button Object | 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) |