Category : Lotus and other Spreadsheets
Archive   : 123LCK23.ZIP
Filename : 123-LOCK.WK1

1
–r


æê
Æ
ÕÆ?ÆÆ 
+,-./ 0 1/


ÿ


ÿ q H
d h
Î@isaaf(h
Ï@isapp(G123-LOCKGLOCK 

GLOOK,,GP000

GP00A

GP00B



GP00P

GP01A

GP01B

GPASSFAILURE

GPRINT//G\0,,G\O,,ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿç0
ÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$
%òWS: COST ACCTN. &ò 15:02 '((
ðB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ˜ÿÿšÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ“ÿÿ“ÿÿÿÿÿÿ–ÿÿ–ÿÿÿÿÿÿÿÿÿÿÿÿARNING! ASSWORD VIOLATION ATTEMPTED BY: AS TRIED TO BREAK THE PASSWORD qq

ÿ' ÿ
' 123-LOCKÿ' Version 2.3 ÿ+'\0(ÿ,'{BREAKOFF}{HOME}{MENUBRANCH LOOK}(ÿ'produced by Softsmith Enterprisesÿ,"{BRANCH \0}ÿ' tmë'{DOWN 2}LOCK~{RIGHT}/FCCNLOCK~123-LOCK~/RNCLOCK~.{RIGHT 2}{PGDN}{UP 4}~{DOWN 3}/RNLR.{DOWN 13}~{LEFT}{UP 5}{LET PASSFAILURE,""}{{}BREAKOFF{}}{{}LET PASSFAILURE,@IF(@ISSTRING(PASSFAILURE),+PASSFAILURE,""){}}{{}MENUBRANCH LOCK{}}~ÿ+'LOOKÿ,"INSTRUCT
ÿ-'REVEIWÿ.'HOME ÿ/'PRINT
ÿ0'BROWSEÿ1'EXAMPLE&ÿ' (c) 1987 All Rights Reserved)ÿ,"SEE FURTHER INSTRUCTIONS FOR USAGE*ÿ-"SEE PREVIOUS INSTRUCTIONS FOR USAGEÿ.'GOTO BEGINNING OF MANUALFÿ/"PRINT A COPY OF INSTRUCTIONS AFTER YOU'VE FINISHED READING THEM<ÿ0'BROWSE THROUGH SUMMARIES OF OTHER SOFTSMITH PRODUCTS.Aÿ1'See an example of 123-Lock integrated in this spreadsheet.ÿ'LOCK ÿ 'BLANK
ÿ
'FREEZEÿ'PASSWORDXÿ,'{if @cellpointer("contents")<>"123-LOCK End:"}{ONERROR \0}{PGDN}{MENUBRANCH LOOK}ÿ-'{PGUP}{MENUBRANCH LOOK}ÿ.'{BRANCH \0}1ÿ/'/RELOCK~{ONERROR \0}/PPRA1..h232~AGPPQ/WEY.ÿ0'{goto}a141~{menubranch look}{branch \0}Iÿ1' ENTER PASSWORD TO GET CONTROL OF FILE!{P00A}{ESC}Hÿ' (versions of this product prior to 2.2 were not published)Pÿ "BLANK SCREEN UNTIL PASSWORD IS TYPED IN (CONTROL RETURNS IN "READY" MODE)Pÿ
'FREEZE KEYBOARD UNTIL PASSWORD IS TYPED (CONTROL RETURNS IN PRESENT MODE)ÿ'CHANGE PASSWORDÿ,"{branch print}Wÿ '{BREAKOFF}{ESC 8}{INDICATE PASSW}/GRGQ{PANELOFF}{WINDOWSOFF}{GRAPH}{BRANCH P00A}ÿ
"{INDICATE PASSW}ÿ'{BRANCH P00B}ÿ ' This product
 ' ISN'T1ÿ 'copy-protected. This spreadsheet has beenÿ 'P00A±ÿ
'{BREAKOFF}{IF @IF(@ISSTRING(P00P)=0,0,@LENGTH(P00P))=0}{LET P00P,""}{BEEP}{BEEP}{BEEP}{BEEP}{BEEP}{BEEP}{ESC 8}BAD PASSWORD- ENTER NEW PASSWORD:{P01B}{ESC 8}{BRANCH P00A}*ÿ
' restricted from direct access
'only ÿ
'to insure there is alwaysyÿ

‚}ðj{RECALC LOCK}{GET P000}{IF @EXACT(@MID(P00P,

H,1),P000)=0}{LET P01A,0}

{BRANCH P00A}3³ÿ

{RECALC LOCK}{GET P000}{IF @EXACT(@MID(P00P,0,1),P000)=0}{LET P01A,0}{ESC} INCORRECT KEYSTROKE!!!{WAIT @NOW+@TIME(0,0,2)}{ESC}{menubranch look}{BRANCH P00A} ,
-
.
/
0
Kÿ' an unaltered copy of the facility for backup and distribution.<ÿ
'{LET P01A,P01A+1}{IF P01A<@LENGTH(P00P)}{BRANCH P00A} , - . / 0F ' PLEASE DON'T ATTEMPT TO RESAVE THIS SPREADSHEET FILE!5ÿ
'{LET P01A,0}{INDICATE}{INDICATE}{RETURN}{QUIT} , - . / 0 >ÿ

'(You may inadvertently lose your copy of the facility!)ÿ
'P00BDÿ

'{BREAKOFF}{INDICATE OLD ?}{P00A}{INDICATE NEW ?}{LET P00P,""} ,
-
.
Nÿ' User agreement, manual and registration form are all available atÿ 'P01B>ÿ
'{GET P000}{IF @LENGTH(P000)>1}{BEEP}{BEEP}{BRANCH P01B} - .Mÿ' this point provided you have a printer on-line. You may proceedUÿ
'{IF P000<>"~"}{LET P01A,P01A+1}{IF P01A<239}{LET P00P,+P00P&P000}{BRANCH P01B} , -Jÿ' to view the documentation on your screen using the "INSTRUCT"xÿ
|}ði{IF P01A>238}{BEEP}{BEEP}{BEEP}-==>PASSWORD SIZE EXCEEDED WITH CHARACTER(S):
€€{INDICATE}{QUIT}3dÿ
{IF P01A>238}{BEEP}{BEEP}{BEEP}-==>PASSWORD SIZE EXCEEDED WITH CHARACTER(S): D{INDICATE}{QUIT} , -Kÿ' and "REVEIW" commands, or you may get your hardcopy (and auto-4ÿ
'{IF @LENGTH(P00P)=0}{BEEP}{BEEP}{BRANCH P01B} -Mÿ' matically exit this file) immediately using the "PRINT" command.Cÿ
'{LET P01A,0}{INDICATE}{RECALC LOCK}{RETURN}{MENUBRANCH LOCK} -O' Instructions for installing the facility in your Lotus files follow...ÿ 'P00Pÿ
'PASSWORD -ÿ"Installing 123-LOCK:ÿ 'P000ÿ
'Dÿ 'P01A
ÿ
Eÿ
'#1- Go to an empty range in your spreadsheet at least 10 wide ÿ "PASSFAILUREbÿ
'{ESC} INCORRECT KEYSTROKE!!!{WAIT @NOW+@TIME(0,0,2)}{ESC}{menubranch look}8ÿ
' by 56 deep. 123-Lock will be installed here.?ÿ
'#2- Insert 123-Lock disk in default drive (usually "b:");ÿ
'#3- Make sure the mode indicator (upper right) says  'READYLÿ
'#4- Type "/FCCN123-Lock" [PRESS RETURN TWICE] continue typing "/RNC\"5ÿ
' "/RNC\" (don't type the quotation marks!).?ÿ
'#5- Now specify a letter you want to use when you invokeBÿ
!' 123-Lock (The facility will activate whenever you typeFÿ
"' "ALT" and the letter at the same time) [PRESS RETURN TWICE]?ÿ
$'#6- Press "ALT" and your chosen letter at the same time.<ÿ
%' (Be sure 123-Lock disk is still in default drive)Cÿ
''#7- After a few moments, 123-Lock will be installed- try it.ÿ('Using 123-LOCK:Dÿ
*'#1- When 123-Lock is invoked, a menu is brought up that givesCÿ
+' you a choice about how you want to lock up the facility. 
-'BLANK
-'FREEZE-'PASSWORDCÿ
/'#2- The "Blank" command will blank-out you screen. Then youAÿ
0' must strike any key to make the facility ready to readCÿ
1' your password (passwords set using "Password" command). <ÿ
2' After striking any key, then type you password...<
3' NOTE THE FACILITY CHECKS FOR UPPER OR LOWER CASE!@
4' FOR EXAMPLE: "PASSWORD" IS NOT THE SAME AS "Password"Dÿ
5' After typing you password, you're returned to Ready mode.Eÿ
7'#3- The "Freeze" command will freeze you keyboard, but neitherFÿ
8' your screen or Lotus 123 will be affected. The facility isBÿ
9' immediately ready for your password. After typing yourEÿ
:' password you'll be returned to the exact point you were at%ÿ
;' when you invoked 123-Lock.ÿ<'Using 123-LOCK:Eÿ
>'#3- The "Password" command allows you to change your password..ÿ
?' #3a- When this function is invoked, ?'OLD ?ÿ?'shows in:ÿ@'the upper-left box of the screen (the "indicator").;ÿA'You must type your old password before 123-Lock willÿB'allow a password change.A
D'Note the password when you got the facility was "PASSWORD"ÿ
F' #3b- "ÿF'After typing the password,  F'NEW ?ÿF'shows in the<ÿG'indicator. At this point you may type any assorment =ÿH'of characters you can remember less than 239 in total.<
J' NOTE THE FACILITY CHECKS FOR UPPER OR LOWER CASE!@
K' FOR EXAMPLE: "PassWord" IS NOT THE SAME AS "pASSwORD"=ÿM'Invalid keys will beep when pressed, they won't affect<ÿN'password input in anyway. Pressing [RETURN] implies 'ÿO'you have finished your password.#ÿP'123-LOCK technical features:Dÿ
R'#1- The range "P00A" contains the main locking routine of theDÿ
S' facility. By calling it as a routine (command = {p00A} )Fÿ
T' the macro designer can embed automatic security anywhere inDÿ
U' his own macros, since the keyboard will be automatically Eÿ
V' locked-up until the correct password is typed. ProvisionsFÿ
W' for personnel who don't know the password can be made using1ÿ
X' the PASSFAILURE range discussed below.Cÿ
Z'#2- By naming your current 123-Lock macro "\0," you can put Bÿ
[' automatic security on a file as soon as it's retrieved.?ÿ
]'#3- By naming 123-Lock "\0" and naming the file it's in Dÿ
^' "AUTO123" and saving AUTO123 to your Lotus system disk orDÿ
_' directory, you can put automatic security on your copy ofÿ
`' Lotus 123!Dÿ
b'#4- Simply by typing "123" on a line in a "AUTOEXEC.BAT" fileCÿ
c' in your root directory, you can secure you whole system!#ÿd'123-LOCK technical features:Cÿ
f'#5- A range named "PASSFAILURE" is created when 123-Lock is Aÿ
g' installed. This range can have a macro routine storedEÿ
h' in it, allowing the user to specify what actions should beAÿ
i' taken when the first incorrect key is pressed during aCÿ
j' regular password check. Look at this menu, named "LOOK"ÿ
l"INSTRUCT
ÿl'REVEIWÿl'HOME ÿl'PRINT
ÿl'BROWSEl'EXAMPLE!m'See example of 123-Lock...
n'{p00a}Cÿ
o' This menu is actually installed in this manual (does it Aÿ
p' look familiar?) simply calling the routine "P00A" (seeBÿ
q' above) suspends execution until a password is typed in.Bÿ
r' With the first incorrect keystroke, the routine in the (ÿ
s' range "PASSFAILURE" executes:ÿt' PASSFAILUREÿt'{MENUBRANCH LOOK}Dÿ
u' by putting the menubranch command in passfailure, you can@ÿ
v' customize 123-Lock's reaction to incorrect passwords!9
w'NOTE THAT THE PASSWORD FOR THIS FILE IS "PASSWORD"ÿx'123-LOCK User Agreement:Eÿz'You are hereby provided a license to use 123-Lock provided the>ÿ{'following conditions typical of public domain software:Bÿ
}'#1- No receipt of any form of remuneration or considerationCÿ
~' for distribution of this product to others beyond those 9ÿ
' verifiable costs of disks, P.C. rentals, ect. Dÿ
'#2- In no event will the author be liable to you or any otherEÿ
‚' person for any damages direct, incidental or consequentialCÿ
ƒ' arising out of the use or inability to use this product.Eÿ
…'#3- No billing is assessed for copies of 123-Lock aquired fromDÿ
†' BBS's dealing in public domain software. Inquiries about?ÿ
‡' commercial distribution of 123-Lock under license of-ÿ
ˆ' Softsmith Enterprises are welcome.ÿ
‰'9ÿŒ'Other products developed by Softsmith Enterprizes:Ž'123-LEARN:Bÿ
Ž' 123-Learn brings the "learn mode" available in Symphony toEÿ
' 123 version 2.0 and up! This facility records all keystrokesAÿ
' you make in a macro, without disturbing your 123 session.Dÿ
‘' Beyond learn mode, you can also embed pauses, input fields, Cÿ
’' decisions, and command repetitions in a macro without even Aÿ
“' looking at it or interrupting your present work. AutomateCÿ
”' your spreadsheets without typing one macro command! Please>ÿ
•' read a full description of this product's features in .ÿ
–" "123learn.ad" included in the archive.™'123-APGR:Eÿ
™' This automated spreadsheet finds the average periodic growthFÿ
š' rate and standard error of any time series data as a percent,Cÿ
›' useful in forecasts and measuring your performance againstCÿ
œ' financial targets (usually expressed as percentages also!)$ÿ
ž'PLEASE SEE ORDER FORMS BELOW!(ÿ 'Softsmith Enterprises order form: ÿ¡|::ÿ¢\_ÿ£\_ÿ
£\_ÿ£'| Place |ÿ¤\_ÿ
¤\_ÿ¤'| Stamp |ÿ¥\_ÿ
¥\_ÿ¥'| Here |ÿ¦'`-------'ÿ«'Softsmith Enterprisesÿ¬'1425 Denman Avenueÿ­'Coshocton, Ohio 43812ÿ³\_ÿ
³\_ÿ³\_ÿ³\_ÿ³\_ÿ³\_ÿ³\_ÿ³\_ÿ´'fold hereÿÆ\_ÿ
Æ\_ÿÆ\_ÿÆ\_ÿÆ\_ÿÆ\_ÿÆ\_ÿÆ\_ÿÇ'fold hereJÿÈ'YES! The marked Softsmith products sound like boons to my office or9ÿÉ'business' productivity! Please ship right away...DÿË' PRICE BILLING IF CHECK IS NOT ENCLOSED,IÿÌ'123-Lock vers. 2.3 $20.00 ________ ENTER CREDIT/BANK CARD NUMBER ¢ÌFÿÍ'123-Learn vers. 2.3 $35.00 ________ __________________________ ¢ÍKÿÎ'123-APGR vers. 1.0 (FREE with your order - please read descriptionGÿÏ' NAME OF BANK OR CREDIT CARDGÿÐ'TOTAL BILLING ___________________________+ÿÑ' ======== ¢Ñ ¢ÒKÿÓ' ==> All Softsmith products are unprotected and freely copyable <== ¢ÓIÿÔ' Ohio residents include 5½% sales tax DO NOT SEND $CASH$ ÕSÿÖ' --(tear)------------(tear)------------(tear)------------(tear)---------- ÿ×|::Bÿ
Ù'(Above is your payment envelope- please fold and seal edges<ÿ
Ú' and sides, fill out return address, stamp and send!)ÿÜ'123-LOCK End:Aÿ
ß'Thank you for your time thus far. Hopefully 123-Lock willEÿ
à'become a valuable productivity tool to you. If not, or if youEÿ
á'see room for improvements, please use the registration form toCÿ
â'let us know. User supported software cannot require billingÿ
ã'of unsatisfied users...Dÿ
æ'Note: Lotus and 123 are trademarks of Lotus Development Corp.(ÿê'Please print manual at this time!
ÿ
' !)
ÿ
' ==ÿ
' !!!