affordable+microsoft word courses+london - Macros

Hi Esther

Thanks for your question.

In both Word and Excel, you start the process of recording a macro by going to Tools - Macro - Record new macro. You should first see a dialogue box that allows you to name your macro and put in a description for it if you wish.

From here you carry out the steps in the task you want the macro to perform, then click the Stop recording button on the little macro recording toolbar on your screen (or go to Tools - Macro - Stop Recording).

The only other thing you have to be aware of is that if your macro in Excel is designed to work with a formula, you will need to click on the Relative references button before you begin recording your macro so that the movements of your mouse are recorded in the macro rather than the names of the actual cells you use.

thanks
Amanda