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?
 
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

Similar Threads

Assign a macro to a button 4
Excel 2003 - assign macro to custom toolbar button 1
Assign Add-In to Custom Toolbar Button Microsoft Office 2007 1
In Excel 2007 how do I customize a button on toolbar 1
Command Button Excel 2007 4
How to assign macro coding into customized button? 4
Inserting a Graphic on a Button when the Button is Assigned to a M 2
How to remove customized button from toolbar? 1

Top