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

  • Thread starter Thread starter Nemo
  • Start date Start date
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?
 
Back
Top