Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

want to add the button on the excel sheet and trigger the macro from that button

Posted on 2011-05-04
3
Medium Priority
?
243 Views
Last Modified: 2012-08-14
want to add the button on the excel sheet and trigger the macro from that button
0
Comment
Question by:koala-london
  • 3
3 Comments
 
LVL 23

Assisted Solution

by:Brian Gee
Brian Gee earned 2000 total points
ID: 35695974
Which version of Microsoft Office Excel are you using?
0
 
LVL 23

Accepted Solution

by:
Brian Gee earned 2000 total points
ID: 35696126
Excel 2003:

Go to Tools > Customize > select the Commands tab from the Customize window > scroll down in the Categories: window pane and then select Macros > find your macro from the right-side Commands: window pane > click and drag it to the toolbar section in-between any toolbar buttons you see present. After you're done, click Close. Your macro will be able to be executed from this toolbar button now.

Excel 2010:

File > Options > Customize Ribbon section (left side) > go to the Choose Commands From dropdown box and select Macros > click to select the macro you want to add to your toolbar > go to the right-most pane and expand the Home section > click on Home to select it > click the New Group button > click the Add >> button > click OK. Now if you go to the Home tab, you will see your macro available as a button to click and execute.

0
 
LVL 23

Assisted Solution

by:Brian Gee
Brian Gee earned 2000 total points
ID: 35696173
Adding buttons to the Ribbon in Excel 2007 is not graphically-based (like the above explained processes), and involves XML manipulation. You can, however, easily add buttons to the Quick Access Toolbar.

Go to Office icon in the upper-right corner > Excel Options > Customize button on left side nav > go to the Choose commands from: dropdown box and select Macros > click to select your macro from the resulting list > click the Add >> button > click OK. Now you will see your macro as a button in the Quick Access Toolbar next to the Save, Undo, and Redo buttons that are there by default.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question