How do I add a macro to a menu button?

  • Thread starter Thread starter mhillis
  • Start date Start date
Place the button on your sheet. Right Click on the button and select "View
Code". This opens the VB editor to the module for the button. Enter your
macro here. If you have recorded a macro elsewhere, cut and paste works
well, too.
 
sorry, missed the part about the "Menu". This is for a "command" button in a
spreadsheet.
 
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

'Cannot insert object' message when I try to put a button on a worksheet 7
In Excel 2007 Can I keep my macros under Menue button like 2003? 1
How can I add sound to a macro button in excel? 2
Customizing Menus in Excel 2007 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Megastat add-in for Excel 2007 11
i created a macro in a xlstart folder.how do i do to insert in too 1
add macro button 2007 2

Back
Top