Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macro

ResolvedVersion 2003

Karen has attended:
Excel Introduction course
Excel Intermediate course
Word Advanced course
Excel Advanced course

Macro

what is a macro

RE: macro

Hello Karen
Thank you for your question

When you have something you need to do over and over again you can write or record a macro to do it for you so you dont have to manually go through the steps each time. You can then attach the macro to a button in excel which can be clicked to perform the task or you could have it so that it automatically runs upon saving. You can use the macro recorder to build them which is best for beginners or directly write them in code if you are more advanced.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.