Thread: how to navigate through unprotected cells only in a worksheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how to navigate through unprotected cells only in a worksheet
If your cell sequencing is left to right and top to bottom, simply unlock
the cells you wish to move to.

Lock all others and Protect the Sheet under ToolsProtection.


Gord Dibben MS Excel MVP

On Thu, 23 Oct 2008 11:35:01 -0700, VictorO
wrote:

I have created a template in a work sheet that contains only a few variables
that need information to be enter by the user. How do I get the user (with
the TAB Key or any other key) to move from unprotected cell to unprotected
cell skiping protected cells in between?

Reply With QuoteReply With Quote