Locks a Window so it's formula cannot be cleared or edited.
WINLOCK(win, lock)
win |
- |
Optional. A Window. Defaults to the current Window. |
||||
lock |
- |
Optional. An integer, the lock mode:
If lock is unspecified, returns the current lock status. |
winlock(W3, 1)
locks the formula of Window 3.
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.