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