Category : Lotus and other Spreadsheets
Archive : ZMACROS.ZIP
Filename : Z.WKS
Output of file : Z.WKS contained in archive : ZMACROS.ZIP
L B ) '* ÿÿ ÿÿ ÿÿ ÿÿ - µÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ qq ÿ '{end} F ÿ 'Worksheet Z is the Z-macro library. To set up Z-macros in your
ÿ '{down} C ÿ 'own worksheet, put the cell pointer where you want them, and ÿ '/rnlr~~ E ÿ 'give the command /File Combine Copy Entire Z. Then, LEAVE THE ÿ '/xg\~ B ÿ 'CELL POINTER IN THE SAME PLACE, and give the command /Range ÿ '\ E ÿ 'Name Create \Z to name the first cell on the left. And run Z. ÿ '\ E ÿ 'When it's through it gets you [Home]. See worksheet ZSTARTER. ÿ '\ ÿ '\ C ÿ 'Another way to set up Z-macros is to copy, name and run the ÿ '\ F ÿ 'bootstrap macro from ZSTARTER. That's what runs the first time ÿ '\ E ÿ 'you run Z in ZSTARTER - it has the same effect as the keyboard ÿ
'\ @ ÿ
'instructions above. Check out ZSTARTER before you go on. ÿ '\ ÿ '\ ÿ ' 2 ÿ 'The definitions below of macros A through W ÿ
'\ 3 ÿ
'let you run up to 24 Z-macros at a time from ÿ '\ 0 ÿ 'the keyboard. That way you don't have to ÿ '\ 2 ÿ 'select each one in turn as the macro that Z ÿ '\ 4 ÿ 'runs when you run Z. And you can even change ÿ '\ 2 ÿ 'each of them on the fly: see X and Y below. ÿ '\ ÿ '\ 2 ÿ 'If your worksheet already contains keyboard ÿ '\ 3 ÿ 'macros, rename or convert them after you set ÿ '\ & ÿ 'up the Z-macros. See ZSTARTER. ÿ '\ ÿ '\ 5 ÿ 'Keyboard macros you name after setting up the ÿ '\ 5 ÿ 'Z-macros get priority. So you can rename the ÿ '\ 3 ÿ 'existing macros back to their previous names ÿ '\ 1 ÿ '(unless they were labeled \X, \Y or \Z) to ÿ '\ ÿ 'avoid converting them. ÿ '\A
ÿ '/xc
ÿ '\A\
ÿ '\0\ 2 ÿ 'A runs the Z-macro named on the left in \A\ ÿ '\ ÿ '~/xq ÿ '\B
ÿ '/xc
ÿ '\B\
ÿ '\0\ 2 ÿ 'B runs the Z-macro named on the left in \B\ ÿ ! '\ ÿ ! '~/xq ÿ " '\C
ÿ " '/xc
ÿ # '\C\
ÿ # '\0\ 2 ÿ # 'C runs the Z-macro named on the left in \C\ ÿ $ '\ ÿ $ '~/xq ÿ % '\D
ÿ % '/xc
ÿ & '\D\
ÿ & '\0\ 2 ÿ & 'D runs the Z-macro named on the left in \D\ ÿ ' '\ ÿ ' '~/xq ÿ ( '\E
ÿ ( '/xc
ÿ ) '\E\
ÿ ) '\0\ 2 ÿ ) 'E runs the Z-macro named on the left in \E\ ÿ * '\ ÿ * '~/xq ÿ + '\F
ÿ + '/xc
ÿ , '\F\
ÿ , '\0\ 2 ÿ , 'F runs the Z-macro named on the left in \F\ ÿ - '\ ÿ - '~/xq ÿ . '\G
ÿ . '/xc
ÿ / '\G\
ÿ / '\0\ 2 ÿ / 'G runs the Z-macro named on the left in \G\ ÿ 0 '\ ÿ 0 '~/xq ÿ 1 '\H
ÿ 1 '/xc
ÿ 2 '\H\
ÿ 2 '\0\ 2 ÿ 2 'H runs the Z-macro named on the left in \H\ ÿ 3 '\ ÿ 3 '~/xq ÿ 4 '\I
ÿ 4 '/xc
ÿ 5 '\I\
ÿ 5 '\0\ 2 ÿ 5 'I runs the Z-macro named on the left in \I\ ÿ 6 '\ ÿ 6 '~/xq ÿ 7 '\J
ÿ 7 '/xc
ÿ 8 '\J\
ÿ 8 '\0\ 2 ÿ 8 'J runs the Z-macro named on the left in \J\ ÿ 9 '\ ÿ 9 '~/xq ÿ : '\K
ÿ : '/xc
ÿ ; '\K\
ÿ ; '\0\ 2 ÿ ; 'K runs the Z-macro named on the left in \K\ ÿ < '\ ÿ < '~/xq ÿ = '\L
ÿ = '/xc
ÿ > '\L\
ÿ > '\0\ 2 ÿ > 'L runs the Z-macro named on the left in \L\ ÿ ? '\ ÿ ? '~/xq ÿ @ '\M
ÿ @ '/xc
ÿ A '\M\
ÿ A '\0\ 2 ÿ A 'M runs the Z-macro named on the left in \M\ ÿ B '\ ÿ B '~/xq ÿ C '\N
ÿ C '/xc
ÿ D '\N\
ÿ D '\0\ 2 ÿ D 'N runs the Z-macro named on the left in \N\ ÿ E '\ ÿ E '~/xq ÿ F '\O
ÿ F '/xc
ÿ G '\O\
ÿ G '\0\ 2 ÿ G 'O runs the Z-macro named on the left in \O\ ÿ H '\ ÿ H '~/xq ÿ I '\P
ÿ I '/xc
ÿ J '\P\
ÿ J '\0\ 2 ÿ J 'P runs the Z-macro named on the left in \P\ ÿ K '\ ÿ K '~/xq ÿ L '\Q
ÿ L '/xc
ÿ M '\Q\
ÿ M '\0\ 2 ÿ M 'Q runs the Z-macro named on the left in \Q\ ÿ N '\ ÿ N '~/xq ÿ O '\R
ÿ O '/xc
ÿ P '\R\
ÿ P '\0\ 2 ÿ P 'R runs the Z-macro named on the left in \R\ ÿ Q '\ ÿ Q '~/xq ÿ R '\S
ÿ R '/xc
ÿ S '\S\
ÿ S '\0\ 2 ÿ S 'S runs the Z-macro named on the left in \S\ ÿ T '\ ÿ T '~/xq ÿ U '\T
ÿ U '/xc
ÿ V '\T\
ÿ V '\0\ 2 ÿ V 'T runs the Z-macro named on the left in \T\ ÿ W '\ ÿ W '~/xq ÿ X '\U
ÿ X '/xc
ÿ Y '\U\
ÿ Y '\0\ 2 ÿ Y 'U runs the Z-macro named on the left in \U\ ÿ Z '\ ÿ Z '~/xq ÿ [ '\V
ÿ [ '/xc
ÿ \ '\V\
ÿ \ '\0\ 2 ÿ \ 'V runs the Z-macro named on the left in \V\ ÿ ] '\ ÿ ] '~/xq ÿ ^ '\W
ÿ ^ '/xc
ÿ _ '\W\
ÿ _ '\0\ 2 ÿ _ 'W runs the Z-macro named on the left in \W\ ÿ ` '\ ÿ ` '~/xq ÿ a '\ 1 ÿ a 'With the cell pointer in the column on the ÿ b '\ 3 ÿ b 'left, press [End][Up] for comments on above. ÿ c '\ ÿ d '\X ÿ d '/rnd\X\~ ÿ d ' 4 ÿ d 'X gets (got?) you here and points to the cell
ÿ e '\X\ ÿ e '/rnc\X\~~ ÿ e ' . ÿ e 'on the left that contains the name of a ÿ f '\ ÿ f '{goto}\\\~ ÿ f ' 0 ÿ f 'Z-macro. It's the one you last confirmed ÿ g '\
ÿ g '/xq ÿ g ' 1 ÿ g 'with Y for Z to run - next time YOU run Z. ÿ h '\ ÿ h ' . ÿ h 'If you didn't confirm one for Z yet, it ÿ i '\ ÿ i ' ) ÿ i 'contains \0\. And Z does nothing. ÿ j '\ ÿ j ' ÿ k '\Y ÿ k '/c~\Y\~ ÿ k ' 2 ÿ k 'To confirm your choice, run Y with the cell ÿ l '\ ÿ l '{goto}\{?}\~ ÿ l ' 0 ÿ l 'pointer on its name. To make a different ÿ m '\ ÿ m '/c\Y\~~ ÿ m ' 0 ÿ m 'choice, move the cell pointer down to the ÿ n '\ ÿ n '/c\\~\\\~ ÿ n ' 3 ÿ n 'name you want on one of the following pages. ÿ o '\ ÿ o '{goto}\X\~ ÿ o ' 4 ÿ o 'THEN run Y to confirm your choice. (The ONLY ÿ p '\
ÿ p '/xq ÿ p ' . ÿ p 'place you should run Y is when the cell
ÿ q '\Y\ q ÿ q ' % ÿ q 'pointer is on a Z-macro name). ÿ r '\ ÿ r ' ÿ s '\Z
ÿ s '/xc ÿ s ' 4 ÿ s 'Y displays "Enter address to go to: \" in the ÿ t '\\
ÿ t '\0\ ÿ t ' 4 ÿ t 'control panel when you run it. Press [Enter] ÿ u '\ ÿ u '~/xq ÿ u ' 4 ÿ u 'for Z to run your Z-macro. Or enter a letter
ÿ v '\Z\ v ÿ v ' 4 ÿ v '(A through W) for that macro to run it. Or Y
ÿ w '\0\
ÿ w '/xr ÿ w ' F ÿ w 'to cancel Y. But mostly you'd press [Enter]. [PgDn]... ÿ x '\ ÿ x ' ÿ y '\ ÿ y ' C ÿ y 'And here are the Z-macro names. They can be any legal range ÿ z '\ ÿ z ' C ÿ z 'names, but these examples follow the description of reserved ÿ { '\ ÿ { ' A ÿ { 'names in ZSTARTER. They're all in the column on the left. ÿ | '\ ÿ | ' ÿ } '\ ÿ } '/rnc\0.~~ ÿ } '\0.. @ ÿ } 'This Z-macro sets up a numbered list of the colors of the ÿ ~ '\ 1 ÿ ~ '/rnd\0.~{end}{home}{down}{end}{left}{down} ÿ ~ ' E ÿ ~ 'rainbow at the bottom left of the worksheet and points to it. ÿ '\ B ÿ '1{down}2{down}3{down}4{down}5{down}6{down}7{end}{up}{right} ÿ ' C ÿ 'It must be run before any of the other examples that use the ÿ '\ O ÿ 'Red{down}Orange{down}Yellow{down}Green{down}Blue{down}Indigo{down}Violet ÿ ' C ÿ 'list. Choose it by placing the cell pointer on its name and ÿ '\ 4 ÿ '{left}{end}{up}/rnc\0.~{end}{down}{right}~/xr ÿ ' E ÿ 'running Y. Press [Enter] when Y pauses. Then, when Y returns ÿ '\ ÿ ' ; ÿ 'you to your place, you can run Z to run the Z-macro. ÿ '\ ÿ ' ÿ '\ ÿ '{goto}\0.~ ÿ '\1.. C ÿ 'Point to the list of colors created by \0.. and sort them in ÿ '\ ) ÿ '/dsd\0.~p\0.~~~{esc}{right}~a~g/xr ÿ ' ÿ 'alphabetic order. ÿ '\ ÿ ' ÿ '\ ÿ '{goto}\0.~ ÿ '\2.. C ÿ 'Point to the list of colors created by \0.. and sort them by ÿ '\ " ÿ '/dsd\0.~p\0.~~~{esc}~d~g/xr ÿ ' ! ÿ 'wavelength (longest last). ÿ '\ ÿ ' ÿ '\ ÿ '/xi\Y\~/xg\3~ ÿ '\3.. # ÿ 'Toggle between \1.. and \2.. ÿ '\ ÿ '/df\Y\~1~~~/xc\1..~/xr ÿ ' F ÿ ' [PgDn]... ÿ '\3 ÿ '/df\Y\~0~~~/xc\2..~/xr ÿ ' ÿ ' ÿ '\ ÿ '/xm\4.M~ ÿ '\4.. D ÿ 'Display a 1-2-3 menu offering a choice of the above Z-macros. ÿ '\
ÿ '/xr ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' ÿ '\ ÿ ' F ÿ ' [PgDn]... ÿ '\ ÿ '{goto}\Z~ 2 ÿ 'The macro on the left is the second part of ÿ ¡ '{down}{down} 1 ÿ ¡ 'the macro that starts in the first cell of ÿ ¢ '{down}{down} 2 ÿ ¢ 'worksheet Z. It's always at the end of the ÿ £ '/rnlr{end}{down}~ / ÿ £ 'Z-macros but before any menus they call. ÿ ¤ '{goto}\X~{right} ÿ ¥ '/rnll{left}{left} 4 ÿ ¥ 'The empty cells in the column on its left are ÿ ¦ '{end}{down} 0 ÿ ¦ 'important. Make sure they're still there ÿ § '{right}{right}~ 4 ÿ § 'after you've made any changes to worksheet Z. ÿ ¨ '/rnc\\\~~/c\\~~ ÿ © '{goto}\0\~{right} 2 ÿ © 'And double check that the first cell of the
ÿ ª '/rnll~ 0 ÿ ª 'macro is lined up with the last \ in the ÿ « '{goto}\~{left} . ÿ « 'filled labeling column above left. The ÿ ¬ '{end}{down} 2 ÿ ¬ 'labels start again next to the menus below. ÿ '/rnlr{end}{down}~ ÿ ® '{home}/xq F ÿ ³ ' [PgDn]... ÿ ´ '\4.M ÿ ´ 'Make ÿ ´ 'Alpha ÿ ´ 'Wave ÿ ´ 'Cycle ÿ ´ 'Quit ÿ µ '\ < ÿ µ 'Draw up a numbered list of the colors of the rainbow. + ÿ µ 'Sort the colors in alphabetic order. . ÿ µ 'Sort them by wavelength (longest last). 1 ÿ µ 'Alternate between the two ways of sorting. < ÿ µ 'When you want to run another keyboard macro (like X). ÿ ¶ '\ ÿ ¶ '/xc\0..~ ÿ ¶ '/xc\1..~ ÿ ¶ '/xc\2..~ ÿ ¶ '/xc\3..~
ÿ ¶ '/xq ÿ · '\ ÿ · '/xg\4..~ ÿ · '/xg\4..~ ÿ · '/xg\4..~ ÿ · '/xg\4..~ ÿ ¸ '\ ÿ ¹ '\ ÿ º '\ ÿ » '\ ÿ » 'LIMIT 6 ÿ » 'This range is always at the end of worksheet Z. ÿ ¼ '\ ÿ ¼ 'Stack ÿ ½ '\ ÿ ½ 'Stack ÿ ¾ '\ ÿ ¾ 'Stack ÿ ¿ '\ ÿ ¿ 'Stack ÿ À '\ ÿ À 'Stack ÿ Á '\ ÿ Á 'Stack ÿ Â '\ ÿ Â 'Stack ÿ Ã '\ ÿ Ã 'Stack < ÿ Ã '(Keep this stack with your Z-macros for compatibility ÿ Ä '\ ÿ Ä 'Stack ÿ Ä ' with future versions). ÿ Å '\ ÿ Å 'Stack ÿ Æ '\ ÿ Æ 'Stack ÿ Ç '\ ÿ Ç 'Stack ÿ È '\ ÿ È 'Stack ÿ É '\ ÿ É 'Stack ÿ Ê '\ ÿ Ê 'Stack ÿ Ë '\ ÿ Ë 'Stack 3 ÿ Ë 'This is the last labeled row in worksheet Z. ÿ Ì 'FLOOR < ÿ Ì 'This is the last row of worksheet Z. It's unlabeled.
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/