Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add macro to toolbar in XP?

Status
Not open for further replies.

ech

Instructor
Oct 9, 2001
42
US
How can I assign a macro to the toolbar in Excel XP? I did it once, but haven't been able to recreate what I did. Does the same method work in 2000?

Word is easy - it can be dragged to the toolbar from the Customize box, but I'm struggling in Excel.
 
I've just tried it and it works for me the same as 2000.

Right click a toolbar and select Customize. Click the Commands tab and select Macros. Drag either the 'custom menu item' or 'custom button' onto the toolbar, then right click the new button and choose assign macro. Hope that helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top