Excel 2007 -- Assign a macro to a button


S

Steve

How can I assign a macro to a button?
Can I create a new button and put it on the Quick Toolbar?
 
Ad

Advertisements

R

Ron de Bruin

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

Top