View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how to navigate through unprotected cells only in a worksheet

Hi,

When you protect the sheet make sure the option that allows user to select
protected cells is un-checked.

Mike

"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?