Protects the current sheet against changes with a password.
All cells that will be locked (cell format) will not be editable. A write attempt by the user causes a box to be displayed informing him that he can not access the contents of the cell or its properties.
Cells previously unlocked by the user will be editable.
Syntax
CHGVAR VAR(&CMD)VALUE('XLPROTECT')
CHGVAR VAR(&PARM1)VALUE('Password')
CHGVAR VAR(&PARM2)VALUE(' ')
CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT +
&PARM1 &PARM2 &RESULT)
Parameters
|
Parameters |
|
|
Parm1 |
Password to protect the current sheet. To remember to remove the protection. |
|
|
See also