WINLOCK

Purpose:

Locks a Window so it's formula cannot be cleared or edited.

Syntax:

WINLOCK(win, lock)

win

-

Optional. A Window. Defaults to the current Window.

lock

-

Optional. An integer, the lock mode:

0:

Unlock window formula

1:

Lock window formula

If lock is unspecified, returns the current lock status.

Example:

winlock(W3, 1)

 

locks the formula of Window 3.

Remarks:

Locked Windows cannot be removed. If no mode is specified, WINLOCK reports the lock status of the Window. Locked Windows can be useful when creating analysis template worksheets.

 

Unlike PROTECT, WINLOCK allows the Window data to be updated as a result of a calculation.

See Also:

CLEAR

CLEARDATA

PROTECT

PROTECTWIN