Macro Documentation

Documentation

When you begin creating macros, create a file to store the macros information in it. The file should contain a list of all the macros in table format. The table should include three columns for the following:

• MacroName, 
• shortcut keys, and 
• description.

As you make more macros add them to the list.

This is how to be a good programmer. It is good for you and for those who follow you in the job.

Some Macros you will only use once a year at year end reports. You have to remember what it did and what the shortcut key is. Having documentation will help you.

Name		ShortCut Key		Description
CurrencyZero		CTRL SHIFT Z		Formats selected cells with Currency with Zero decimal places

Macros: Where to start

Before creating a macro, the following steps will make the task easier. Many people get stressed once a recorder is turned on. They will ease the stress! These steps will also save you time later when there are problems.

1. Write down a summary of what the macro is going to do. A small paragraph or sentence is good. 
2. Write down the step by step instructions of what you want the Macro will do. Use the computer. 
3. Follow the steps you have written down to ensure you have not forgotten anything. It is good to ask someone else to go through the steps to verify this. 
4. Now you are ready to create the macro. 

Following these steps will save you time trying to figure out what it is wrong with your macro. We call that debugging. They will also help you be more confident when creating your macros.