Category : Lotus and other Spreadsheets
Archive   : ZMACROS.ZIP
Filename : ZSTARTER.WKS

Ò/


ÿ


ÿq H\Zi
mÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0
ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%ò&ò'((
LB)
'*ÿÿÿÿÿÿÿÿ-µ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
Oÿ'FIRST... X MARKS YOUR PLACE : /File Retrieve ZRELEASE forNÿ
' Yes : an overview of Z-macros inMÿ' Yes : a release dated 11-25-85.Oÿ' Yes :............................,ÿ' Yes+ÿ' Yes*ÿ' Yes)ÿ' Yes(ÿ' YesIÿ 'THEN... Y CONFIRMS YOUR CHOICE...of Z-macro!&ÿ
' YesHÿ' Yes from JUST DISCS...Lÿ ' Yes phone orders (206) 384-3660Dÿ
' Yes $15 + $4 s/hNÿ' Yes 10:00am to 2:00pm Pacific TimeNÿ' Yes ...VISA accepted. ÿ' Yesÿ' Yesÿ' YesOÿ'SO THAT... Z RUNS YOUR Z-MACRO [PgDn]...6ÿ' Welcome to ZSTARTER and the idea of Z-macros.Nÿ' A Z-macro is one of what can be a large number of macro routines thatEÿ' are called by Z (by default). So when YOU run Z, Z runs IT./ÿ' On the pages below, ZSTARTER shows you@ÿ' How to load Z-macros into this worksheetLÿ' How to check out the Z-macros, choose one and run it/ÿ ' How to create a Z-macroEÿ"' How to load Z-macros into any other worksheetIÿ$' How to add regular macros to your Z-macro libraryGÿ&' How to run regular macros and Z-macros togetherOÿ'' [PgDn]...@ÿ)' HOW TO LOAD Z-MACROS INTO THIS WORKSHEETMÿ,' The first time you run macro Z, it combines worksheet Z, the Z-macroLÿ-' library, into this worksheet. It goes on automatically to name andOÿ.' set up the Z-macro examples so they're ready for you to select and runMÿ/' them. This bootstrap macro takes several seconds, but only needs toLÿ0' run once in each worksheet's lifetime. Z gets you [Home] when it'sGÿ1' done; just press [PgDn] a couple of times to get back to here.ÿ3' Now run Z.Oÿ5' You run Z like any other keyboard macro - by keying its letter shiftedLÿ6' with the alternate shift key. So, if you haven't done it yet, hold"ÿ7' down [Alt] and press [Z].Oÿ;' [PgDn]...Lÿ=' HOW TO CHECK OUT THE Z-MACROS, CHOOSE ONE AND RUN ITAÿ@' X marks your place and takes you to the Z-macros9ÿC' where=ÿF' Y confirms your choice!ÿI' so that@ÿL' Z runs it. Any time...any place...So run X now!OÿO' [PgDn].../ÿQ' HOW TO CREATE A Z-MACRONÿS' Move the cell pointer to the cell on the left boundary of the Z-macroNÿT' area where you want to insert your new Z-macro. Give a /Move commandNÿU' with [End][Home][Enter] marking the end of the range to be moved. Go,ÿV' ahead and move it down, say a page.MÿX' Enter your Z-macro in the column on the right of the boundary cells,KÿY' which you must be sure are all filled - usually with the \ symbol,MÿZ' unless there are cells in your macro you want to name (to branch to,Hÿ[' or use for data). Each Z-macro must end with /xr, for example:ÿ]'\ÿ
]'^Jan
ÿ]'\137../ÿ]'Make column titles for First Half Reportÿ^'\Bÿ
^'{right}^Feb{right}^Mar{right}^Apr{right}^May{right}^Jun~/xrNÿ`' Move the bottom part of the Z-macros back up for a snug fit, and nameNÿa' your new Z-macro: put the cursor on its name (\137.. here) and give a)ÿb' /Range Name Labels Left command.Oÿc' [PgDn]...Eÿe' HOW TO LOAD Z-MACROS INTO ANY OTHER WORKSHEETMÿg' EITHER key the commands described in worksheet Z, OR use this macro:ÿi'{goto}Z1~?ÿ
i' Point to the cell where worksheet Z is to be combined.ÿj'/fcceZ~.ÿ
j' Combine an entire copy of the file Z.ÿk'/rnd\Z~9ÿ
k' Delete the range name of this bootstrap macro Z.ÿl'/rnc\Z~~Fÿ
l' Create a range name \Z for the first cell of the worksheet Z.
ÿm'/xg\Z~)ÿ
m' Go on executing the macro at \Z.Oÿo' The range of cells that consists of the macro and its comment is namedOÿp' \Z. So you can /File Combine Copy Name \Z [Enter] ZSTARTER [Enter] toOÿq' get it into your worksheet. And /Range Name Create \Z [Enter] [Enter]Oÿr' to set it up as the bootstrap macro Z. If you like, you can change Z1Gÿs' in the first line to some other cell. Then run Z. That's it!Oÿu' *** Load Z-macros before naming other macros. Reserved labels: \, \\,Mÿv' \\\, \X, \Y, \Z, \a\ and \n (a is a letter, n starts with a number).Oÿw' [PgDn]...Iÿy' HOW TO ADD REGULAR MACROS TO YOUR Z-MACRO LIBRARYNÿ{' The easiest way to see this is to take another look at Z-macro \137...ÿ|' from two pages up. Here it is again:ÿ~'\ÿ
~'^Jan
ÿ~'\137../ÿ~'Make column titles for First Half Reportÿ'\?ÿ
'{right}^Feb{right}^Mar{right}^Apr{right}^May{right}^Jun~ÿ€'\
ÿ
€'/xr2ÿ' And how it would look as regular macro H: ÿƒ'\Hÿ
ƒ'^Jan/ÿƒ'Make column titles for First Half Report?ÿ
„'{right}^Feb{right}^Mar{right}^Apr{right}^May{right}^Jun~
ÿ
…'/xqMÿ†' You can see what you have to change: the label and its position, theOÿ‡' left boundary and the ending. And insert it in worksheet Z to make itMÿˆ' a permanent addition to your Z-macro library; or just in the Z-macroMÿ‰' area for temporary use. See HOW TO CREATE A Z-MACRO (two pages up).NÿŠ' When Y pauses for you to press [Enter] as a default, enter H instead.Oÿ‹' [PgDn]...Gÿ' HOW TO RUN REGULAR MACROS AND Z-MACROS TOGETHERMÿ' You can have macros A through W entirely outside the Z-macro system.Oÿ' But you should load them, or at least (re)name them after the Z-macrosOÿ‘' have been set up. That's because labels \A through \W are used in theOÿ’' Z-macro library to name macros that each call a Z-macro whose name canOÿ“' be supplied at your option each time you run Y. (The default is for Y0ÿ”' to supply the name to Z for Z to call).Oÿ–' The names of your regular macros won't work after the Z-macros are setMÿ—' up, so be prepared to reload them. Or have some way of finding themMÿ˜' to rename them - each with its previous name, if you like, unless itNÿ™' was \X, \Y or \Z. But you make your macros more flexible if you giveKÿš' their first cells names other than \A, \B, etc. Like \COLHEAD forMÿ›' instance. And treat them like Z-macros (although they may not be inKÿœ' the Z-macro area): run X, run Y (default, just to get back), thenLÿ' with the cell pointer on the new name, run Y again. Enter whatever?ÿž' letter you like (A-W) when Y pauses, and...you got it!OÿŸ' [PgDn]...=ÿ¡' (c) Copyright 1985, George Atherton, Vancouver, B.C.Aÿ£' 1-2-3 is a trademark of Lotus Corporation, Cambridge, MAMÿ¥'The coined word, Z-macro, is a trademark property of the publisher of ÿ¦'this material,Dÿ¨' JUST DISCS #276A, P.O. Box 34069, Seattle, WA 98124-1069Mÿª'Anyone may make and distribute free copies of this disk for personal Lÿ«'or business use, but no part of the material may be used in a productNÿ¬'that's sold - without written permission from the author and publisher.Lÿ­'Reasonable care must be taken to ensure that all copies are complete.Nÿ®'To get a warranted unmodified copy of the most recent version, send $15Oÿ¯'to the publisher; or phone (206) 384-3660 from 10:00am to 2:00pm PacificLÿ°'Time, and pay by VISA. (There's an additional $4 handling charge forLÿ±'phone orders). As a paying customer you receive a disk, a money-backNÿ²'guarantee and a $5 credit note you can use as part payment for the nextCÿ³'version...and a letter about that when it's ready to ship...Mÿµ'...that's it, except for a text file named READ.ME! you can call up onMÿ¶'the screen outside of 1-2-3 by responding to the DOS prompt, A> (or B>Mÿ·'or whatever) with the command TYPE READ.ME! Or you can just give the Bÿ¸'command GO to see the same stuff with built-in page breaks.Nÿº'JUST DISCS are interested in what you would like to see in ZSTARTER andOÿ»'Z in the future, and in giving you credit for your suggestions. Detailsÿ¼'are in READ.ME!IÿÈ' You can run X any time you want to mark your place and go to theOÿÉ' Z-macro area, where you make your choice and confirm it with Y. Run YOÿÊ' ONLY when the cell pointer is on the name of a Z-macro (or equivalent)MÿË' that you want to confirm as your choice to have tied to Z or anotherKÿÌ' letter (A through W, unless the letter is being used for a regularOÿÍ' macro). If/when you run Y out of turn, you can recover: when Y pausesNÿÎ' for you to press [Enter] or to enter a letter, enter Y. Y copies theNÿÏ' "name" into a cell where it does no harm, instead of into a macro forOÿÐ' that macro to call. Y returns you to where you last ran X. (NormallyOÿÑ' the sequence is X Y Z). Final point: if you're following a menu, Quit@ÿÒ' it when you want to run a macro. Like X, for instance.