Macro Basics

1. Set Macro Placement
In step defines the macro, you must plan carefully how broad group worksheet that will be occupied, taking into account the amount of data and memory capacity that is owned.
In general can give examples of division between the location and placement worksheet Macro programs, such as group A1 through Z50 for the worksheet, and then to occupy the Macro program began AA51 group. To speed to the location of writing macros, use the F5 function key or command GOTO. For example: GOTO AA51.

2. Writing a Macro Program
a. Writing a Macro Name
If you want to name the Macro with the name of a program, step looks like:
'(Signs Pick / Apostrophe)
\ (Lines Lean Back / backslash)
a (letter available on alfabeta)

Need quotation marks in written to mark that the write is the label. If you directly write \ a, it will show a row of letter a letter of column width.

b. Writing Macro Commands
If you want to write the command / wsc25 ~, the step of writing as follows:
'(Signs Pick)
/ (Line Tilt / Slash)
w (Worksheet)
c (Create)
s (Setup)
25 (which in the desired column width)
~ (Tilde), Identical to the Return / Enter

Need quotation marks in written for Lotus 1-2-3 does not go directly to the command mode.

c. Writing a Macro Description
Description Macros can actually get rid of because it will not affect the course of the program macros. Only suggested to the write down so you can easily analyze the Macro program if at some point want to make changes to the program.

3. Running Macros
Macro programs can be run by pressing the Alt key and a letter that called the program simultaneously Macro Macro When the program is running, a indokator at the bottom of the screen shows the CMD.

4. Stopping Macro
If the program is running Macro and want the stop, press the Ctrl and Scroll Lock keys simultaneously. To return to ukerja sheet mode, press the Esc (Escape).

5. Editing Macros
If the program macros that you create needs to change, use the F2 key, which works together with the workings of the worksheet mode.

6. Macro Checking
If the program that created Macro still not perfect, you can perform a thorough examination by running step by step. For that press the Alt and F2 to initiate the inspection mode.

7. Macro Unstructured
In order for the program can be done easily use structured programming techniques. Similarly, in the writing of macros, use macro structure. The example below menunkkan techniques and writing Macros Macros unstructured Unstructured.

Macro Program unstructured
AA51: '\ a
AB51: '\ ppcrA1.X25 ~ agpagpagpagpq

Macro Program structure
AA51: '\ a
AB51: '\ ppcr
AD51: Preparation Printing
AB52: A1.X25 ~
AD52: Force who wanted to be in print
AB53: agp
AD53: Print and print resume
AB54: agp
AD54: The second printing
AB55: agp
AD55: The third printing
AB56: agpq
AD56: The final print and exit from the print menu