Category : Lotus and other Spreadsheets
Archive   : HOWTOMAC.ZIP
Filename : HOWTOMAC.WK1

å
–`å

¬
å
D´
Ò
2d
'ÂKD
KK KS

S
áS
:
D

:
D
:
D
:
D
/


ÿ


ÿ —
q —
H 
  
 
ÿ d G1G2))G22»»G3``G4ˆˆG5¯¯G6ÄÄG7ÙÙG8



G9)
)
GAGAIN
Ê
ÊGBEGININGòòGBEGINING[1];
;
GBEGINING[2]
ó
óGCONVENTIONSu
GCOUNTER
î
îGCOUNTER[1]
;

;
GDECIMALSääGEND_
_
GENDAREAGEXAMPLES`~
GHOWTOMACé

GINSTRUCTIONSƒ
ƒ
GMAIN
q

q
GMENU
>
?

GMENU MACROS



GMENU[1]



GMSGb
d

GMSG BOARD
GMSGAREA

GNAMES«
«
GNAMING MACROSˆ«
GNUMBERS»Â
GRANGE NAMES«
«
GREPEAT
ä
äGREPEAT[1]
5

5
GREPEAT[2]ââGSET


GSTART»»GTIMES
ï
ïGTIMES[1]
<

<
GTOP
Î
ÎGWELCOME—
 

G\0
n

n
G\A
n

n
G\B
4

4
G\C
¦
¦G\D
ã
ãG\E
¸
¸G\F
´
´G\GááG\I
p
pG\L
É
ÉG\M



G\N
¶
¶G\P
¨
¨G\V
[

[
ÿÿ ÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿé
0

;

;
ÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿ# ÿÿÿÿÿÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
%ò&ò'(\015 (
ðB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
!
' Building a Complex Macroÿ'(from the beginning) 
#ÿ
'1. Getting Started...Basics0ÿ
'2...Release 1A Macro Symbols and Commands#ÿ
'3...Examples and Conventionsÿ
'4...Naming Macrosÿ

'5...Simple Macrosÿ
'6...Loops5ÿ
'7...Controlled Loop (Counter & User Modified) ÿ
'8...Menu Macros!ÿ
'9...Controlled Loop (Menu)"'1'Getting Started...BasicsOÿ' Macros execute 1-2-3 operations automatically by reading a "record" Nÿ' of the keystrokes you would use to perform those operations manually.ÿ' It works this way:Iÿ' -- The desired keystrokes are placed in single cells as labels.Oÿ' -- If more than one cell is needed the next cell immediately below isÿ ' used.Oÿ"' -- Macros read from left to right in a SINGLE column. The first cell4ÿ#' then the next cell below, and so forth.Eÿ%' -- When an empty cell is encountered in the column it ends. ''PgDn )'2)'Release 1A Macro Symbols*' Keystrokes+' Commands (PgDn)Kÿ-' The symbols between the {brackets} are used in macros to representLÿ.' the movement and function keys. Those with a * are Release 2 only.ÿ
1'Keystrokeÿ1'Keystroke
ÿ2'Symbolÿ
2'Meaning
ÿ2'Symbolÿ2'Meaning
ÿ3'------ÿ
3'-------
ÿ3'------ÿ3'-------ÿ4'~ÿ
4'Enter, or return keyÿ4' *ÿ4'{insert}+ÿ4'Togles between insert and overwrite.ÿ5'{up}ÿ
5'Up-arrow ÿ5'{del}ÿ5'Delete key
ÿ6'{down}ÿ
6'Down-arrow
ÿ6'{edit}ÿ6'Edit key (F2)
ÿ7'{left}ÿ
7'Left-arrow ÿ7'{abs}"ÿ7'Absolute reference key (F4)ÿ8'{right}ÿ
8'Right arrowÿ8'{table}$ÿ8'Recalculate a data table (F8)
ÿ9'{home}#ÿ
9'Positon Cell Pointer to homeÿ9'{graph}ÿ9'Redisplay a graph
ÿ:'{goto}ÿ
:'Go to a cell (F5) ÿ:'{esc}ÿ:'Escape Key
ÿ;'{pgup}ÿ
;'Page upÿ;'{bs}ÿ;'Backspace key
ÿ<'{pgdn}ÿ
<'Page downÿ<' *
ÿ<'{name}0ÿ<'Displays list of range names in worksheetÿ='{window}$ÿ
='Change window on split screenÿ='{query}"ÿ='Perform database query (F7} ÿ>'{end}ÿ
>'End key
ÿ>'{calc}ÿ>'Recalculate (F9)
ÿ?'{?}ÿ?'Pause for input from3ÿ@'* {bigright} Moves pointer right one screenÿ@'user, wait for a press2ÿA'* {bigleft} Moves pointer left one screenÿA'the enter key.%C'Release 1A Macro Commands (/x) DNÿE' Macro commands are used in macros to perform specific functions, likeLÿF' branching to a subroutine, calling a menu, etc. The /x commands mayMÿG' also be used in Rel 2. The Rel 2 alternative is shown to the right. ÿI^Macro ÿ
I' Release 2 MacroÿJ^CommandÿJ'Function*ÿJ'(Tab Right---->for Rel. 2 commands)ÿ
J' CommandsÿK' -------|ÿ
K\-ÿK\-ÿK\-ÿK\-ÿK\-ÿK\-ÿK\-ÿK\-ÿ K\-#ÿ
K'---------|------------------ÿL' /xi |Fÿ
L'If..Then. If the condition being tested is true, then the macro ÿ
L' | {If condition}ÿM' |Fÿ
M'processes the rest of the cell. Otherwise, it continues processÿ
M' |ÿN' |,ÿ
N'ing the macro at the next cell below.ÿ
N' |ÿO' |ÿ
O' |ÿP' /xg |Cÿ
P'Makes the macro skip to another cell to continue processing.#ÿ
P' | {Branch location}ÿQ' |ÿ
Q' |ÿR' /xc,/xr|Eÿ
R'/xc calls a subroutine, and /xr returns execution to the posi-!ÿ
R' | {Name} {return}ÿS' |$ÿ
S'tion just after the /xc call.ÿ
S' |ÿT' |ÿ
T' |ÿU' /xq | =ÿ
U'Quits execution of the macro and returns to ready modeÿ
U' | {Quit}ÿV' |ÿ
V' |ÿW' /xl |Eÿ
W'Pauses execution, displays a message in the control panel and #ÿ
W' | {Getlabelprompt} ÿX' |Cÿ
X'waits for a response. Responce is a label and is placed in aÿ
X' |ÿY' |+ÿ
Y'specified location on the worksheet.ÿ
Y' |ÿZ' |ÿ
Z' |ÿ[' /xn |7ÿ
['Same as above, but treats the input as a number.ÿ
[' | {Getnumber}ÿ\' |ÿ
\' |ÿ]' /xm |Eÿ
]'Creates a menu of choices in the control panel, waits for user&ÿ
]' | {Menubranchlocation}ÿ^' |Dÿ
^'to select a menu item, then executes a macro based on choice.ÿ
^' |ÿ
_' |`'3`'Examplesa'--------Kÿb' The three simple macros below are examples of how to write macros.Kÿc' The 1st macro formats a specified range of cells for currency withNÿd' two decimal places. The 2nd would print the macro conventions below.Lÿe' This macro uses a range name for the print range. In the 3rd macroNÿf' the keystrokes are placed vertically in adjacent cells of the column.Iÿg' Each macro, if named and activated, would execute the keystrokesÿh' therein.
ÿ
j
 l' 1stÿ
l'/rfc~B107..B107~'ÿl'Formats for currency, 2 decimals m n' 2ndÿ
n'/pprCONVENTIONS~agpq)ÿn'Prints the macro conventions below "o p' 3rd ÿ
p'/fÿp'Saves already named fileÿ
q'sÿ
r'~ÿ
s'rs'PgDnu'Conventionsv'-----------Kÿw' The following conventions for writting macros help to clarify them4ÿx' so that they may be more easily understood.?ÿz' 1. Write keystrokes and macro commands in lower case.:ÿ|' 2. Cell addresses and range names in UPPER case.Pÿ~' 3. Place range names used in a macro just to the left of named ranges.Oÿ€' 4. Formulas in lower case, except for embedded addresses/range names,Pÿ' examples: @sum(B12..D24), @If(INTEREST<.095,"REFINANCE","KEEP").Pÿƒ' 5. Place the macro in convenient place i.e AA1. Try to be consistent.Kÿ„' Apply the range name MACROS to the area containing the macros.Nÿ†' 6. Place documentation for the macro a couple of spaces to the rightÿ‡' of the macro.ˆ'4ˆ'Naming Macros5ÿŠ' The following rules apply for naming macros.#ÿŒ' Invoked from the keyboard: ÿ' LÿŽ' 1. Only one character and it must be an alphabetic character or 0.7ÿ' 2. It must be preceeded by a (\). Example: \SPÿ' 3. Choose a name that helps describe the macro i.e. \S for save macro.Bÿ‘' 4. Use the /Range Name Create command to name the macro.Pÿ’' 5. Need to name only the first cell in the range containing the macro.Kÿ“' 6. The Range Name Labels Right command can be used if the name isPÿ”' placed in the cell just to the left of the first cell in the macro.Lÿ•' 7. To invoke the macro press the Alt key and macro name key at the'ÿ–' same time. Example: ALT S%ÿ˜' Invoked from within a macro: ÿš' 1. \NAME, NAME, \?, \1š'PgDnKÿœ' Two of the three macros below (same as the ones you saw earlier inMÿ' module 3) have been named and can be invoked by pressing the Alt keyLÿž' and the letter name of the macro (shown just to left of the macro). ' Reminder.......:ÿ 'Do not save this worksheet. If for some reason you4ÿ¡' get messed up ..retrieve it and start over.
ÿ¤
¢
¤'<--cell to be formated ¢¤ ¢¤ÿ¤' Documentation ÿ¦'\Cÿ
¦'/rfc~A165..D165~'ÿ¦'Formats for currency, 2 decimals ÿ¨'\Pÿ
¨'/pprNAMING MACROS~agpq&ÿ¨'Print macro, prints this module ¢© ÿ
ª'/fs~r*ÿª'Saves already named file (not named%ÿ«'to prevent inadvertent saving)"¯'5¯'Simple MacrosOÿ°' The range format macro below is used to show how a macro can work overOÿ±' a range of cells using range names and the {end} and {down} keys. LookIÿ²' them over. Press Alt and the macro name letter to try them out. ÿ´'\Fÿ
´'/rfc~22~,ÿ´'Formats "22" for currency, 2 decimals ÿ¶'\Nÿ
¶'/rfc~NUMBERS~,ÿ¶'Same as above but range is "numbers". ÿ¸'\Eÿ
¸'{goto}START~.ÿ¸'Same as above but uses end down keys toÿ
¹'/rfc~{end}{down}~%ÿ¹'specify the range coordinates.
ÿ»ÿ
»'<--formatÿ»' |--
ÿ»8ÿ»'Start-->
ÿ»"ÿ¼' |
ÿ¼N
ÿ¼ÿ½' |
ÿ½[
ÿ½
ÿ¾'Numbers->
ÿ¾5
ÿ¾Iÿ¿' |
ÿ¿
ÿ¿NÿÀ' |
ÿÀ
ÿÀ\ÿÁ' |ÿÁ' -----ÿÁ' -----ÿÂ' |--ÿÂÐs@ €ù¿€þ¿P
ÿÂps@ €ù¿€þ¿P
Ä'6 Ä'LoopsMÿÆ' Loops are used to repeat previously executed keystrokes. The macro PÿÇ' below shows how this works. Try it, but read the highlited note first. ÿÉ'\Lÿ
É'{goto}TOP~*ÿÉ'Positions pointer at top of column. ÿÊ'Again
ÿ
Ê'/rfc~~(ÿÊ'Formats for currency, 2 decimals.
ÿ
Ë'{down}#ÿË'Moves pointer down one cell.ÿ
Ì'/xgAGAIN~*ÿÌ'Loops back to /rfc~~ (named Again),ÿÍ'repeats format.ÿÎ' Top-->
ÿ
Î
ÿ
Ï#
ÿ
ÐC
ÿ
Ñ**Ñ'Infinite Loop-- requires Ctrl/Break
ÿ
ÒÒ'keys to terminate.
ÿ
Ó]
ÿ
Ô
ÿ
Õ=ÿ
Ö' --------ÿ
×°v@ €÷¿€þ¿P
Ù'7 Ù'Controlled Loop (Counter)#ÿÙ' Tab Right - Modified--->-
Ù' Controlled Loop (User Modified)MÿÛ' To control the number of repetitive keystrokes a counter can be usedPÿ
Û'This macro differs from the controlled loop (counter) macro by prompting KÿÜ' to limit the number of iterations to a preset number. Look at theMÿ
Ü'the user to enter the number of decimals wanted. The macro also givesAÿÝ' macro below. When ready, PgDn to see the macro execute.Oÿ
Ý'the user the option of setting a new decimal value or stopping the macro@ÿ
Þ'with the Ctrl Break keys. PgDn to see and run the macro.Jÿß' After trying the controlled loop macro below go to K217 (F5 K217)?ÿà' to see a modified version of this macro with a prompt. ÿ
á'\Gÿá'{goto}BEGINING[2]~ÿ
â'Repeat[2]+ÿâ'/xlEnter no. of decimals :~DECIMALS~ ÿã'\Dÿ
ã'{goto}BEGINING~*ÿã'Positions pointer at top of column.ÿã'/rfc
ÿä'Repeat
ÿ
ä'/rfc~~(ÿä'Formats for currency, 2 decimals.ÿ
ä'Decimals----------->ÿä'0ÿ
å'/dfCOUNTER~COUNTER+1~~~+ÿå'Sets up counter with /Data Fill cmd.ÿå'~ÿ
æ'/xiCOUNTER=TIMES~/xq*ÿæ'Tests COUNTER vs TIMES, quits if =.ÿæ'{end}{down}~
ÿ
ç'{down}#ÿç'Moves pointer down one cell.ÿç'{?}~ÿ
è'/xgREPEAT~+ÿè'Loops back to /rfc~~ (named Repeat),ÿè'/xgREPEAT[2]~)ÿé'repeats the currency format 9 moreÿê'for a total of ten.)ÿë'Number of times format is desired.ë'PgDnì"PgDnLÿ
ì'This macro prompts the user for the desired number of decimal places.Lÿ
í'The number of decimals is entered by the macro at the end of the /rfcÿî'CounterKÿ
î'command and is followed by a tilde (~) which executes it. The {end} ÿï'Times
ÿ
ï
Lÿ
ï'{down} fills the range to be formated. The {?} waits for the user toLÿ
ð'decide wether to ask for a new prompt to reset the number of decimals=ÿ
ñ'or abort the macro through use of the Ctrl Break keys.!ÿò' Press Alt D to start the
ÿòÿò'<--begining"ÿó' macro. Watch the counter
ÿó#
ÿ
óÿó'Begining[2]"ÿô' above add each itteration
ÿôC
ÿ
ô#ÿõ' as it is completed.
ÿõ*
ÿ
õC
ÿö
ÿ
ö*5ÿö' Press Alt G to invoke the macro. After the "ÿ÷' When the ranges "counter"
ÿ÷]
ÿ
÷2ÿ÷' initial format press enter to get another"ÿø' and "times" are equal the
ÿø6
ÿ
ø]5ÿø' prompt. If you wish to stop, press the Ctrlÿù' macro will end.
ÿùM
ÿ
ù3ÿù' and Break keys at the same time. An errorÿú' --------
ÿ
ú=<ÿú' message will appear in the mode pannel, press enterÿû€y@ €÷¿€þ¿P
 ÿ
û' -----+ÿû' enter to return to the ready mode.ÿ
ü°v@ €÷¿€þ¿P
Kÿý' Go to cell K217 (F5 K217) to see a modified version of this macro.Mÿ
þ' When finished with this macro press F5 and then 8 to go to module 8.

'8

'Menu Macros (/xm)1ÿ
' Menu macros are very powerful and handy.Nÿ
' 1. They are the same as 1-2-3 menus. The 1st line contains the menu8ÿ
' choices. The 2nd line explains the choice. 
 

Nÿ
' 2. The remaining lines hold the keystrokes/commands to be performed.  

Nÿ
' 3. Limit of eight choices per menu. As many instructions as needed.  

Kÿ
' 4. The menu macros must be in adjacent cells (the contents of the  

Lÿ

' cells will overlap and will be difficult to read...no problem).  


Oÿ
' 5. As with other macros, every row must begin with the label prefix '  

Pÿ
' 6. The /xmNAME ({Menubranch}) command is always used to call the menu.  

Nÿ

' 7. Once the menu has been built, name it using the /RN command, both  


Oÿ
' lines (choice and explanation) are in menu range name coordinates.  

 

Nÿ
' Look at the menu macro below. Examine it by placing the cell pointer  

Iÿ
' over the individual cells and reading them in the control panel.
'PgDn  

 ÿ
'\Mÿ

'/xmMENU[1]~  


ÿ
  

ÿ
'Menu[1]ÿ

'Format ÿ
'Print ÿ
'Retrieve ÿ
'Quit
ÿ
  

&ÿ

'Format for currency, 2 decimals+ÿ
'Print this demo (Menu Macros) module$ÿ
'Retrieve this worksheet againÿ
'Quit the menu
ÿ
 

ÿ

'/rfc~SET~ÿ
'/pprMenu Macros~agpqÿ
'/frHOWTOMAC~
ÿ
'/xq ÿ
"--  

ÿ

'/xmMENU[1]~ÿ
'/xmMENU[1]~ÿ
3@ €ü¿€þ¿P
Jÿ
' This macro gives the user several options. The first choice willKÿ
' format the column of numbers at the right. The second choice willKÿ
' print this module. The third choice will retrieve this worksheet.,ÿ
' The last choice will quit the menu.Kÿ"
' Menu macros are a little bit more difficult to document. The nextAÿ#
' module will show a way to do it that will be very clear.Mÿ%
' After you have looked at the menu macro above and understand it, try0ÿ&
' it. Start the macro by pressing Alt M.)
'9)
'Controlled Loop (Menu)Jÿ+
' This macro uses a controlled loop to limit the number of cells itKÿ,
' formats. When the formatting is complete it invokes a menu macro.Mÿ.
' Look it over and when satisfied try it. When you are finished go toMÿ/
' cell I317 to see the menu and its documentation more clearly. Bring'ÿ0
' up the menu by pressing Alt B.  
0
 
1
ÿ2
'Documentation ÿ4
'\Bÿ
4
'{goto}BEGINING[1]~*ÿ4
'Positions pointer at top of column.  
4
ÿ5
'Repeat[1]
ÿ
5
'/rfc~~(ÿ5
'Formats for currency, 2 decimals.  
5
$ÿ
6
'/dfCOUNTER[1]~COUNTER[1]+1~~~*ÿ6
'Set up counter with /Data Fill cmd.  
6
4ÿ
7
'/xiCOUNTER[1]=TIMES[1]~/reCOUNTER[1]~/xmMENU~*ÿ7
'Tests COUNTER vs TIMES, menu if = .  
7

ÿ
8
'{down}#ÿ8
'Moves pointer down one cell.  
8
ÿ
9
'/xgREPEAT[1]~-ÿ9
'Loops back (Again), repeats formating.  
9
ÿ :
\.ÿ
:
\.ÿ:
\.ÿ :
\.ÿ
:
\.ÿ:
\.ÿ:
\.ÿ;
'Counter[1]ÿ;
'Begining[1]-->
ÿ;
Aÿ ;
'Menu macros can be written as subroutines for each choice.  
;
ÿ<
'Times[1]
ÿ
<


ÿ<
#ÿ <
\. 
<
\.ÿ<
\.ÿ <
\.ÿ
<
\.ÿ<
\.ÿ<
\.
ÿ=
Cÿ>
'Menuÿ
>
'Reset ÿ>
'Again ÿ>
'Print ÿ>
'Retrieve ÿ>
'Quit
ÿ>
*ÿ >
'Menuÿ
>
'Reset ÿ>
'Again ÿ >
'Print ÿ
>
'Retrieve ÿ>
'Quit'ÿ
?
'Return format to default setting<ÿ?
'Repeat formatting the column for currency, 2 decimalsIÿ?
'Print this macro demo worksheet (wide carraige paper is suggested)$ÿ?
'Retrieve this worksheet againÿ?
'Quit the menu
ÿ?
'ÿ
?
'Return format to default setting/ÿ?
'Repeat formatting the column, 2 decimalsIÿ ?
'Print this macro demo worksheet (wide carraige paper is suggested)$ÿ
?
'Retrieve this worksheet againÿ?
'Quit the menuÿ
@
'{goto}BEGINING[1]~ÿ@
'{goto}BEGINING[1]~ÿ@
'/ppcarHOWTOMAC~ÿ@
'/frHOWTOMAC~
ÿ@
'/xq
ÿ@
]ÿ
@
'/xgRESET~ÿ@
'/xgAGAIN~ÿ @
'/xgPRINT~ÿ
@
'/xgRETRIEVE~
ÿ@
'/xqÿ
A
'/rfr{end}{down}~ÿA
'/xgREPEAT[1]~ÿA
'os\015~mr240~q
ÿA
ÿ
B
'/xmMENU~ÿB
'agpq
ÿB
=ÿ B
\.ÿ
B
\.ÿB
\.ÿ B
\.ÿ
B
\.ÿB
\.ÿB
\.ÿC
'/xmMENU~ÿC
' --------ÿ C
'SubroutinesÿC
'DocumentationÿD
°v@ €÷¿€þ¿P
ÿ D
\.ÿ
D
\.ÿD
\.ÿ D
\.ÿ
D
\.ÿD
\.ÿD
\. 
F
 ÿ F
'Resetÿ
F
'{goto}BEGINING[1]~-ÿF
'Position pointer at the top of column.ÿ
G
'/rfr{end}{down}~'ÿG
'Reset format to default setting.ÿ
H
'/xmMENU~ÿH
'Return to the menu ÿ K
'Againÿ
K
'{goto}BEGINING[1]~-ÿK
'Position pointer at the top of column.ÿ
L
'/xgREPEAT[1]~+ÿL
'Format column _ currency, 2 decimals ÿ O
'Printÿ
O
'/pprHOWTOMAC~agpqÿO
'Print the worksheet.ÿ
P
'/xmMENU~ÿP
'Return to the menu.ÿ S
'Retrieveÿ
S
'/frHOWTOMAC~ÿS
'Retrieve this file. ÿ[
'\Vÿ
[
'{paneloff}+ÿ[
'This macro is for your EGO. Replaceÿ
\
'{goto}MSG BOARD~&ÿ\
'my name with your's and run it.ÿ
]
'/cMSG~MSGAREA~ÿ
^
'/reMSGAREA~ÿ
_
'/cMSG~MSGAREA~ÿ_
' ** THE END **~ÿ
`
'/reMSGAREA~ÿ
a
'/cMSG~MSGAREA~ÿ
b
'/reMSGAREA~
ÿb
'Msgÿb
' How about that?ÿ
c
'/cMSG~MSGAREA~
ÿc
'----->ÿ
d
'/reMSGAREA~ÿd
'Lets hear it for Vince!ÿ
e
'/cMSG~MSGAREA~ÿ
f
'/reMSGAREA~ÿ
g
'/cMSG~MSGAREA~ÿ
h
'/reMSG BOARD~ÿ
i
'/cEND~ENDAREA~ÿ
j
'{goto}ENDAREA~ ÿn
'\Aÿ
n
'{goto}Welcome~ÿ
o
'{Menubranch MAIN}ÿq
'Mainÿ
q
'Instructions ÿq
'Start ÿq
'Range Names ÿq
'QuitPÿ
r
'Read the instructions on how to use this instructional/demonstration file<ÿr
'See how to build a complex macro (from the beginning)Cÿr
'See the Range Names used in this file and their cell address+ÿr
'Leave the menu, return to ready modeÿ
s
'{goto}INSTRUCTIONS~
ÿs
'{home}ÿs
'{goto}NAMES~
ÿs
'{quit}ÿ
t
'{Menubranch MAIN}
ÿt
'{?}ÿu
'{Menubranch MAIN}=
ƒ
'How to use this instructional/demonstration 1-2-3 fileLÿ…
' There are nine separate modules on this spreadsheet. Each providesKÿ†
' instructions and/or exercises on how to build macros. The modulesMÿ‡
' start with basic exercises and get progressively complex. To move toMÿˆ
' each module use the Goto key (F5) and enter the number of the moduleLÿ‰
' you wish to see. Once in the module, you can move the cell pointerEÿŠ
' about freely to see the instructions and work the exercises.GÿŒ
' When you are through with the exercises, leave the spreadsheetIÿ
' without saving it. This returns all exercises to their originalOÿŽ
' form, ready for the next time you want to use this instructional file.Fÿ
' You may wish to make a backup of this file before proceeding.Mÿ‘
' To start the exercises highlight "Start" in the menu above by movingKÿ’
' the cell pointer to it and pressing enter. To see the Range NamesCÿ“
' used in this file highlight "Range Names" and press enter.Jÿ•
' The main menu above can be accessed from any place in the file by6ÿ–
' pressing the Alt and A keys at the same time.œ
'Welcome!NÿŸ
' This disk contains instructions and demonstrations that will show youKÿ 
' how to build Lotus 1-2-3 Macros. Enjoy! I did, preparing it.Lÿ¢
' The macros used in this demo are simple examples. Their purpose isMÿ£
' to show how macros are written. What is important about them is howMÿ¤
' they work, not what they do. The routines can be used in any macro.6ÿ¦
' Make a choice from the menu above to proceed.«
' Range Names Usedÿ¬
\-ÿ
¬
\-ÿ¬
\-ÿ­
'1
ÿ­
'A21ÿ®
'2
ÿ®
'A420ÿ®
'To browse through the list of range names ÿ¯
'22ÿ¯
'A1880ÿ¯
'use the cell pointer keys {up} or {down}.ÿ°
'3
ÿ°
'A97ÿ±
'4ÿ±
'A1372ÿ±
'When you have finished looking at the rangeÿ²
'5ÿ²
'A1762ÿ²
'names, if you came to this page through useÿ³
'6ÿ³
'A1970ÿ³
'of the main menu, press enter. This willÿ´
'7ÿ´
'A218#ÿ´
'return you to the main menu.ÿµ
'8ÿµ
'A258ÿ¶
'9ÿ¶
'A298 ÿ·
'AGAINÿ·
'B203ÿ¸
'BEGININGÿ¸
'E243ÿ¹
'BEGINING[1]ÿ¹
'H316ÿº
'BEGINING[2]ÿº
'K244ÿ»
'CONVENTIONSÿ»
'A118..I128ÿ¼
'COUNTERÿ¼
'B239ÿ½
'COUNTER[1]ÿ½
'B316ÿ¾
'DECIMALSÿ¾
'L229¾
'More: PgDn
ÿ¿
'ENDÿ¿
'F352ÿÀ
'ENDAREA ÿÀ
'S9ÿÁ
'EXAMPLESÿÁ
'A97..H127ÿÂ
'HOWTOMACÿÂ
'A1..P490ÿÃ
'INSTRUCTIONSÿÃ
'A388ÿÄ
'MAINÿÄ
'B370ÿÅ
'MENUÿÅ
'B319..F320ÿÆ
'MENU MACROSÿÆ
'A258..H285ÿÇ
'MENU[1]ÿÇ
'B281..E282
ÿÈ
'MSGÿÈ
'F355..H357ÿÉ
'MSG BOARDÿÉ
'P1..U20ÿÊ
'MSGAREAÿÊ
'S9..S14 ÿË
'NAMESÿË
'A428ÿÌ
'NAMING MACROSÿÌ
'A137..I172ÿÍ
'NUMBERSÿÍ
'D188..D195ÿÎ
'RANGE NAMESÿÎ
'A428
ÿÏ
'REPEATÿÏ
'B229ÿÐ
'REPEAT[1]ÿÐ
'B310ÿÑ
'REPEAT[2]ÿÑ
'L227
ÿÒ
'SETÿÒ
'H280..H284Ò
'More: PgDn ÿÓ
'STARTÿÓ
'G188 ÿÔ
'TIMESÿÔ
'B240ÿÕ
'TIMES[1]ÿÕ
'B317
ÿÖ
'TOPÿÖ
'B207ÿ×
'WELCOMEÿ×
'A408..H417 ÿØ
'\0ÿØ
'B367 ÿÙ
'\AÿÙ
'B367 ÿÚ
'\BÿÚ
'B309 ÿÛ
'\CÿÛ
'B167 ÿÜ
'\DÿÜ
'B228 ÿÝ
'\EÿÝ
'B185 ÿÞ
'\FÿÞ
'B181 ÿß
'\Gÿß
'L226 ÿà
'\Iÿà
'B113 ÿá
'\Lÿá
'B202 ÿâ
'\Mÿâ
'B279 ÿã
'\Nÿã
'B183 ÿä
'\Pÿä
'B169 ÿå
'\Vÿå
'B348