removeAllEditableCells method



Marks all cells in the worksheet as uneditable by the user when the worksheet is locked.

Syntax

waffleObject.removeAllEditableCells()

Applies to

Waffle class.

Parameters

none.

Return value

none.

Usage

By default, all cells are locked from editing when the worksheet is locked. Call removeAllEditableCells() if you want to prevent users from editing cells which you previously unlocked using addEditableCell().

Example
removeAllEditableCells example

See also
addEditableCell method
lockSheet method
unlockSheet method