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

microsoft excel course - macro create and

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Macro - create and run

microsoft excel course - Macro - create and run

ResolvedVersion Standard

Nicole has attended:
Excel Advanced course

Macro - create and run

How do I create and run a macro?

Thanks!

RE: Macro - create and run

Hi Nicole, Thanks for the post; a macro is a recording of keystrokes and mouse clicks, from when you start recording to when you click the stop recording button. To record a macro choose the Menu command Tools, Macros and choose the option Record New Macro, give the macro a name, choose where to store it and any special information that you wish to assign to it in the Description text box. When you click Ok the macros begins to record your mouse clicks and keystrokes, when you have finished recording the macro press the Stop Recording button, little blue square on the Stop Recording toolbar. To run the macro you can again go to Menu command Tools, Macro and this time choose Macros, from the list choose the macro you wish to run and click OK.

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

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.