Weekly Computer Tip # 351
16 October 2011

Automating repetitive tasks (Microsoft Office 2000-2010)

Back in December 2004 (no, this is not a typo ;) we talked about automating repetitive tasks by creating macros. For example, you might want to use Microsoft's built-in macro recorder to create a keyboard shortcut to "print this page only" in Word.

Here's how:

1. In Office 2000: Choose the Tools, Macro, Record New Macro command. OR
2. In Office 2007: On the Developer tab, in the Code group, click Record Macro. (If you don't see the Developer tab, click the Microsoft Office Button, click Word Options, click Popular and select the Show Developer tab in the Ribbon check box.) OR
3. In Office 2010: On the View tab, choose Macros, Record Macro.

Simply follow the on-screen instructions or see tip # 92 http://www.roem.co.uk/tip_92.html for further details.

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   Virtual Press Room   Disclaimer