macro

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

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

Macro

resolvedResolved · Low Priority · Version 2003

Sultan has attended:
Excel Intermediate course
Excel Advanced course
Outlook Introduction course
Access Introduction course
Access Intermediate course

Macro

How to create Macro?

RE: Macro

1. Click Tools - Macro - Record New Macro. The Record New Macro dialog box will be displayed.

2. Enter a name for the macro. The macro name should not contain spaces, cannot begin with a number and should contain no more than 255 characters.

3. If you want a keyboard shortcut, click the Shortcut key: box, and enter the key you want to use to play back the macro later.

4. Choose where to store the macro. If you choose the Personal Macro Workbook, the macro will be globally available in each workbook you create.

5. Click OK. Perform the tasks that you want to be included in your macro. All your keystrokes and mouse clicks will be recorded until you end the recording process. If you click the Relative Reference button (to right of Stop Rec) the macro recorder will record your keystrokes relative to the actual cell. If the Relative Reference button is not depressed, exact cell references will be recorded.

6. When you have finished, click Stop Rec.

Mon 15 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Creating Quick Column Charts

Select the information you want to appear in the chart and press F11. This creates a new chart on a seperate worksheet.

View all Excel hints and tips


Server loaded in 0.09 secs.