ms excel courses - Macro

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

Resolved · Low Priority · Version Standard

Macro

Sonia has attended:
Excel Intermediate course

by - delegate Sonia [1 post] (2007 Jun 28 Thu, 13:30) Reply

How do you record and run a Macro?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macro

by - trainer Anthony gold contributer [113 posts] (2007 Jun 28 Thu, 16:21) Reply

Select Tools, Macro and then Record New Macro and give your macro a name in the first field of the dialog box which appears. Once you click OK, your every action is being recorded as as macro. Once you've carried out the task, click the stop (square) button on the floating macro toolbar and the macro will stop recording. To run your macro again, select Tools, Macro and then Macros, select the name of your macro and hit run.

· Microsoft Excel Training: Not Just for Newbies Anymore
· Features of Microsoft Excel that assist in Analysis of Financial Data
· How to Create Better Excel Spreadsheets: Part Four
· Benefits of learning about Excel charts
· How to Create Better Excel Spreadsheets: Part Two