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.
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.
Tools>Protection>Protect Sheet. In the options list, deselect "Select locked cells".
Cheers,
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks