Excel 2007 -- Assign a macro to a button

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How can I assign a macro to a button?
Can I create a new button and put it on the Quick Toolbar?
 
Yes this is possible

Right click on the QAT and choose "Customize Quick Access Toolbar".
In the “Choose commands from†dropdown choose "Macro's"

But we have a problem now if you add the button only to your active workbook
In the “Customize Quick Access Toolbar†dropdown choose “For <workbook name>â€.

See this page then
http://www.rondebruin.nl/qatbuttonbug.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning Macros in Excel 2007 1
Edit Button Image in Excel 2007? 4
How to identify macro assigned to toolbar button 3
Excel 2003 - assign macro to custom toolbar button 1
Assign a macro to a button 4
Customizing Menus in Excel 2007 1
In Excel 2007 how do I customize a button on toolbar 1
Command Button Excel 2007 4

Back
Top