The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Macro

Resolved · High Priority · Version 2003

ReplyWed 16 Dec 2009, 13:52Delegate Violette said...

Macro

Could you take me steps by steps how to create a macro and how to run it ?

For upcoming training course dates see: Pricing & availability

ReplyThu 17 Dec 2009, 14:49Trainer Stephen said...

RE: Macro

Hi Violette

Thanks for the question

The following are the main steps in creating a macro

1. Start the Macro Recorder (Tools-Macro_Record New
Macro)
2. Give the Macro a name and click OK. The macro recorder will be running and you will have the stop recording tool bar available
3. Carry out the actions that the macro is to do
4. When finished, click Stop Recording

To run the macro
1.Go ToTools-Macro_Macros
2. Select the Macro to Run
3. Click Run

Hope this is useful

Regards

Stephen

Tue 29 Dec 2009: Automatically marked as resolved.

Excel articles

· Why Should I Learn Visual Basic in Excel?
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Adding Effects To Drawing Objects In Excel
· Want To Create A Presentation In Excel?
· How to Create Better Excel Spreadsheets: Part Three

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

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

I am trying to create a new PT but I keep getting the following message -

The pivot table file name is not valid. To create a pt you must you data that is organised as a list with labeled columns

I'm confused as mine are labeled????

its ok I ha..

» Forum post: Pivot Tables

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions