Skip to content
REFERENCE

U.UNLOCK_CELLS

Summary

Registers a range of cells that should remain unlocked, or just its formulas unhidden, when the workbook is protected using U.PROTECT_WORKBOOK(…)

Syntax

=U.UNLOCK_CELLS(range, [lock_but_show], [apply_now])

Parameters

Parameter Required Description
range Yes The range(s) whose cells should remain unlocked or just visible when the workbook is protected
[lock_but_show] No If set to TRUE then cells will still be locked for editing when the workbook is protected, but the equations will be visible in the formula bar
[apply_now] No If set to TRUE then the settings are applied to the cells immediately. By default the settings are registered and applied when U.PROTECT_WORKBOOK(TRUE,…) is called

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.UNLOCK_CELLS(B117:B118)

=U.UNLOCK_CELLS(B124:B125)

=U.UNLOCK_CELLS(B126,TRUE)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.