UNLOCKED.NEXT, UNLOCKED.PREV macro

Equivalent to pressing TAB or SHIFT+TAB to move to the next or previous unlocked cell in a protected worksheet. Use these functions when you want to control which cell is active on a protected sheet.

Syntax

UNLOCKED.NEXT( )

UNLOCKED.PREV( )

Related Functions

CELL.PROTECTION   Controls protection for the selected cells

PROTECT.DOCUMENT   Controls protection for the active sheet

Return to index