attaching a macro to a control button in the Quick Access Toolbar

N

Nemo

Excel 12, WXP

I have a macro that I used a lot in Excel 11 and I would like to use it in
Excel 12. I have put a button (form control) on the Quick Access Toolbar and
I want to attach the macro to it. Help says to right click on the control
and choose "assign macro" but when I right click on the control I don't get
that choice. Can't find any help for this question in VB editor either. It
describes how to put a command button on the worksheet itself, but no way to
assign a macro that is in the Quick Access Toolbar.

Any suggestions?
 

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

Edit button image of a custom macro on the QuickAccess toolbar 1
Removing a custom Toolbar Button & macro 1
How to record a macro within a macro 9
Macro Button 2
Saving a Macro Button on the Quick Access Toolbar in Excel 1
Command Button 4
Customer Toolbar Issues 1
Button in quick access toolbar 1

Top