Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

Macros

Resolved · Low Priority · Version 2003

Reply Thu 15 Jan 2009, 16:25Delegate Gilly said...

Gilly has attended:
Excel Intermediate course
Excel Advanced course

Macros

How do you set up a macro

For upcoming training course dates see: Pricing & availability

Reply Tue 27 Jan 2009, 14:10Trainer Amanda said...

RE: macros

Hello Gilly

Thank you for your question and welcome to the forum.

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

When you have finished carrying out the steps to that your macro will perform, either click the Stop Recording button on the small toolbar on your screen; or go to Tools - Macro - Stop Recording.

I hope this helps.
Amanda

Tue 3 Feb 2009: Automatically marked as resolved.

Excel articles

· Interesting Lifestyle Applications for Microsoft Excel
· Basic Excel Training
· How Many Different Ways Can You Sum In Excel 2007?
· Learn How To Separate Text In Excel Into Separate Cells
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series

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

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips