Assign a macro to a button

  • Thread starter Thread starter totofab
  • Start date Start date
T

totofab

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.
 
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.
Click to expand...

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!
 
But I'm using 2007.

dksaluki said:
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!
Click to expand...
 
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.
 
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.
 
Back
Top