MACROS
_____________________________________________________________________
Business Computing Tips
By K&K Fainges kfainges@bigpond.net.au
If you find yourself doing the same thing over and over again, record a macro.
It sounds hard, but in Word and Excel, it has become surprisingly easy.
1. First go to Tools => Macro =>
Record New Macro. This starts the macro going behind the scenes.
2. Give it a name, making sure you do not use spaces or punctuation. You can
also assign it a keystroke. That means that you can make the macro work by
just hitting Ctrl and whatever letter you chose. Word 2000 and above also
allows you to assign it directly to a toolbar.
3. Do whatever you want the macro to do. Examples are formatting a page,
wiping all the data from a table, inserting a disclaimer or anything that you
are constantly redoing.
4. Turn off the macro recorder when you finish by clicking the Stop Recording button that appears in the tiny Stop Recording toolbar as soon as you start recording.
it looks just like the stop button on your tape/CD player. It the tool bar
doesn't appear, go to TOOLS => MACROS => STOP RECORDING.
5. Now your macro is ready to go. To run it, just go to TOOLS=>MACROS=>
MACROS and double clicking on the name or pressing Alt+F8. If you assigned a
keystroke or toolbar button, it's even easier.
So if you know there has to be an easier way, try a macro.
***********************************************************************
Please feel free to pass it on to your friends, just let them know I wrote
it.
Karen Fainges holds a Bachelor of Business, and a Grad. Cert of Vocational
and Educational Training. All this is nice but it's the 14 years of having to
make sales or starve that makes her think she has really learnt what does and
doesn't work. A tutor for all ages, she specialises in helping people get
started on the long road to technology.
"It has to be practical, it has to be cheap, and it has to work."
|
