Thread: cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default cells


Jared,

You can if you don't mind protecting the rest of the sheet. Select all
the cells that you want to skip through so they are all highlighted
(start by selecting the first cell, then hold down the control key as
you select the others). Right mouse click, Format Cells, Protection
and deselect the Locked checkbox. Click on OK.

Then protect your sheet making sure that you deselect the "Select
locked cells" option.

The user will then only be able to select the cells that are not
locked. Excel will also only move to the next unlocked cell when the
user hits enter.

HTH

Steve


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