Macro button

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Macro button

Nick has attended:
Access Introduction course

by - delegate Nick bronze contributer [28 posts] (2008 Feb 26 Tue, 12:02) Reply

Can you please tell me how to add a macro "button" - I have set up seveal macros but can only seem to action a macro by using a quick key (i.e. ctl-a) - can you tell me how to set up a macro so that it can be run by pressing a button on screen

Thanks
NICK

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 22 Fri	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003/XP	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003/XP	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2003/XP	2008 Sep 10 Wed	Tooting	0	FULL
Full Schedule: See all 129 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macro button

by - trainer Rich platinum contributer [704 posts] (2008 Mar 1 Sat, 10:16) Reply

Go to view>>toolbars>>forms which shows the forms tool box. There is a button command. click it and draw the button where you want it on the excel sheet. It should automatically have a pop up that allows you to assign a macro to it, but if not then right click and choose assign macro.

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Training: Essential for Today's Employees

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips