Nicole has attended:
Excel Advanced course
Macro - create and run
How do I create and run a macro?
Thanks!
RE: Macro - create and run
Hi Nicole, Thanks for the post; a macro is a recording of keystrokes and mouse clicks, from when you start recording to when you click the stop recording button. To record a macro choose the Menu command Tools, Macros and choose the option Record New Macro, give the macro a name, choose where to store it and any special information that you wish to assign to it in the Description text box. When you click Ok the macros begins to record your mouse clicks and keystrokes, when you have finished recording the macro press the Stop Recording button, little blue square on the Stop Recording toolbar. To run the macro you can again go to Menu command Tools, Macro and this time choose Macros, from the list choose the macro you wish to run and click OK.