2002 excel microsoft training - Macro

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

Resolved · Low Priority · Version Standard

Macro

Carole has attended:
Excel Intermediate course

by - delegate Carole [1 post] (2007 Feb 9 Fri, 15:21) Reply

How do I create a macro?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macro

by - trainer Amanda platinum contributer [947 posts] (2007 Feb 12 Mon, 12:03) Reply

Hi Carole

Thanks for your question.

You can create a macro by going to Tools - Macro - Record New Macro.

Then you can give your macro a name, and carry out the steps that you want the macro to perform when it is run.

Then click the Stop Recording button.

To run the macro, go to Tools - Macro - Macros. You can create a toolbar button to run the macro by going to Tools - Customise - Commands after the macro has been recorded.

Amanda

· Basic Excel Training
· Compare Different MS Excel Training Methods
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Prepare for your MOS Certification with MS Excel Courses
· Reasons Why VBA for Excel Training Fails

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips