How do I duplicate a macro for a button on the Standard Toolbar?

G

Gord Dibben

Suzi

Don't know what you mean by "duplicate" but to place a button on a toolbar and
assign a macro to that button...................

Tools>Customize>Commands.

Scroll down to Macros.

Drag Custom Button to your Toolbar.

Right-click on the button and you have some options.

1. Name the button.
2. Assign macro.
3. Edit button image.
4. Change button image. You have a limited number of choices.

Download John Walkenbach's file Button Faces from here.

http://www.j-walk.com/ss/excel/files/developer.htm

Any of these can be dragged to your toolbar and have a macro assigned.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 15:22:01 -0800, Suzi <[email protected]> wrote:
 

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

Can I edit macro buttons on the quick access toolbar in excel? 0
How to remove customized button from toolbar? 1
Assign a macro so I can just single click it to run it 0
Excel 2007 -- Assign a macro to a button 1
How to assign macro coding into customized button? 4
Excel 2003 - assign macro to custom toolbar button 1
How to identify macro assigned to toolbar button 3
Format a macro button 2

Top