Protect Worksheet


Version: 2023

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-23417


  • Mini toolbar bar button is added to disable/enable editing of sheet. Lock icon shows in front of sheet name

  • Select multiple sheet tabs and right click to protect

  • Context menu in Object Manager to protect sheet(s)

  • Choose Preferences: Protect Sheet Options… menu to customize protection exceptions.

  • System Variable @WPO for exceptions (default 11 - allow mask, sort, and resize col/row and change colors)

@WPO = 0 will lock up all except to change filled color etc.

WPO_COLOR_AND_RESIZE = 0x01,
WPO_MASKING = 0x02,
WPO_SET_DESIGNATION = 0x04,
WPO_REORDER = 0x08,
WPO_CELL_NOTES = 0x10,