Add a custom command to a toolbar

  • Thread starter Thread starter LAURA2018
  • Start date Start date
L

LAURA2018

Does anyone know how to add a button to a tool bar and attach a macro to it. I
wrote a custom macro for my reporting but would prefer not to have to add it to
each of my reports manually. I would like a button on a toolbar to run it on
any report I open. Any suggestions?

Thanks,
Laura
 
Hi Laura,

Right click anywhere on the toolbar > customize > Toolbar Tab> New
then under Commands Tab scroll down to "Macros" and drag a "Custo
Button" onto your custom menu. While in the Commands Tab single clic
the newly created button, "Modify Selection" should activate. You ca
assign macro, edit icon, etc. etc. Also might want to make sure th
macro is stored in PERSONAL.XLS so it can be used in all workbooks.

Best Regards,
Mjac
 
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

Custom Toolbar 1
Easy way to add my custom button on Excel 2010 quick access toolbar? 3
Open and close custom toolbar with workbook 1
Custom Toolbar - "Begin a group" 2
2007 Quick Access Toolbar 2
Add Custom Button to Quick Access Toolbar 4
Customize Quick Access Toolbar 5
Adding a Custom Command Button to the Excel 2007 Ribbon 1

Back
Top