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 · High Priority · Version 2003

Violette has attended:
Excel Advanced course

Macro

Could you take me steps by steps how to create a macro and how to run it ?

RE: Macro

Hi Violette

Thanks for the question

The following are the main steps in creating a macro

1. Start the Macro Recorder (Tools-Macro_Record New
Macro)
2. Give the Macro a name and click OK. The macro recorder will be running and you will have the stop recording tool bar available
3. Carry out the actions that the macro is to do
4. When finished, click Stop Recording

To run the macro
1.Go ToTools-Macro_Macros
2. Select the Macro to Run
3. Click Run

Hope this is useful

Regards

Stephen

Tue 29 Dec 2009: Automatically marked as resolved.


 

Excel tip:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips


Server loaded in 0.1 secs.