Assigning a macro to a toolbar button...How?

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

How do I make the macro i just recorded a button on the standard
toolbar?
 
Tools>Customize>Commands. Scroll down to "Macros" and select.

You will see two items, "Custom Menu Item" and "Custom Button" smiley face.

Drag that button to the Toolbar.

Right-click on it and see the options to re-name, edit, change icon and other
neat stuff.

Note also the "Assign Macro" option. This is where you assign the macro you
just recorded.

Gord Dibben Excel MVP
 
Right Click on toolbar
Select Customize
Select command Tab
Select Macros
Drag Icon on to Toolbar
Right Click on new icon
Select Assign Macr
 
You must log in or register to reply here.

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

Customer Toolbar Issues 1
attaching a macro to a control button in the Quick Access Toolbar 1
How to record a macro within a macro 9
Macro Button 2
Assign a Macro to a Command Button 1
Removing a custom Toolbar Button & macro 1
Problem Assigning Macro to Button 3
Custom Toolbar Problems 2

Back
Top