Macros

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

Resolved · Low Priority · Version Standard

Macros

Jas has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Access Introduction course

by - delegate Jas [2 posts] (2008 Feb 19 Tue, 16:44) Reply

How do you create macros?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Macros

by - trainer Rich platinum contributer [754 posts] (2008 Feb 23 Sat, 22:07) Reply

Go to tools>>Macro>>Record New Macro
Also, you can add the macro button to your toolbars by choosing, view>>toolbars>>visual basic. The toolbar will appear and the little circle is the record button

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel's Best Kept Secret
· Excel Macros for the Non-Programmer
· Take the Anxiety out of Domestic Finances with Microsoft Excel

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

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Rate this page: