Category : Lotus and other Spreadsheets
Archive   : SRBMACRO.ZIP
Filename : SECURE.WK1


–
/


ÿ


ÿ
q H
?d G\E

ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿ†ÿÿ±0
ÿÿÿÿÿÿÿÿì ÿÿÿÿ# ÿÿ
ÿÿ
gÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
%ò ** LATEST CONTROLS BY DUE DATE **|I:\GROUP\PBB\ASSIGNME.WK1|PAGE # &ò '( (
LB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
 ÿ'\0ÿ
'{breakoff}{goto}iv8192~-ÿ

'{getlabel "Enter Password: ",PWORDIN}~$ÿ
'{if PWORDIN<>MYWORD}{WIPEOUT}ÿ
'{blank PWORDIN}{home}ÿ'WIPEOUT
ÿ
'/qyÿ'PWORDIN
ÿ 'MYWORD
ÿ
'macros8ÿ
'This is a simple macro for securing spreadsheets.Cÿ
'To use it change the word "macros" above to any password youAÿ

'select. When you subsequently retrive this spreadsheet itBÿ
'will prompt you for your password. If you get it wrong youDÿ
'will be sent out Lotus 123; if you enter the correct password>ÿ
'you will enter your spreadsheed as normal from the HOMEFÿ
'position. This macro must be named \0 for it to work properly.?ÿ
'I suggest you combine it into an out of the way locationDÿ
'such as HA4000 on the spread sheet you want to protect. ThisEÿ
'is not as sure a protection as is the Lotus password as a fileCÿ
'combine will retreive this spread sheet and won't when usingÿ
'the Lotus password.7ÿ
'This macro will begin automatically if named \0.Fÿ
'If you combined this with another spreadsheet you will have to Dÿ
'name the column to the right of the \0. To do this place theAÿ
'cursor on the \0 and press slash (/), Range (R), Name (N),Bÿ
'Lables (L), Right (R), Page Down and Enter. This will nameAÿ
'the column to the right of the \0 with names under the \0.