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

faye has attended:
Excel Advanced course

Macro

how do i record please

RE: macro

Hello Faye

Thank you for your question and welcome to the forum.

To record a macro:

1. Go to Tools - Macro - Record New Macro.
2. Enter a name for the macro (this cannot include spaces).
3. If you would like to specify shortcut keys to run the macro, or write a comment about what the macro does, you have the options to do this as well.
4. Click OK. Excel now starts to record what you are doing.
5. Go through the steps you would like the macro to take for you.
6. Go to Tools - Macro - Stop Recording.

Kind regards
Amanda

Fri 22 May 2009: Automatically marked as resolved.


 

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips


Server loaded in 0.09 secs.