ExcelBanter - Locked spreadsheet, move cursor only to unlocked cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Locked spreadsheet, move cursor only to unlocked cells? (https://www.excelbanter.com/excel-worksheet-functions/58782-locked-spreadsheet-move-cursor-only-unlocked-cells.html)

dhilligoss

Locked spreadsheet, move cursor only to unlocked cells?

Have created a form in excel that has unlocked cells for data entry.
Would like the cursor to only move to cells that are not locked, skipping
locked cells.

SteveG

Locked spreadsheet, move cursor only to unlocked cells?

ToolsProtectionProtect Sheet. In the options list, deselect "Select
locked cells".

Cheers,

Steve

--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=490726

All times are GMT +1. The time now is 02:49 PM.