Thread: How do I dictate cell to cell progression in a protected worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I dictate cell to cell progression in a protected worksheet
You can give the range a name and ENTER your way through the cells in the order
you wish.

See Bob Phillips's site for methods of naming a range.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Don't be put off by the title "Tab to selected cells". There is a method of
using the ENTER key.

Also see alternate methods of tabbing through using Protected cells.


Gord Dibben MS Excel MVP

On Fri, 1 Sep 2006 09:04:02 -0700, mike wrote:


Gord Dibben MS Excel MVP
Reply With QuoteReply With Quote