Solved

Protected Cell Progression

Posted on 2015-02-21
2
54 Views
Last Modified: 2015-02-22
EE Pros,

I have a WS that has unprotected cells.  When I protect it.... the cursor moves in a pattern that is not what should be followed.  How do I get the next logical cell to be where the cursor moves to when I tab or arrow to the next unprotected cell?

Thank you in advance,

B.
0
Comment
Question by:Bright01
2 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 500 total points
ID: 40623940
When you protect the sheet and choose to allow users to select only unlocked cells, the active cell should move as follows:
Right then down in you press TAB
or
Down  then right if you press RETURN

What behaviour are you getting?
0
 

Author Closing Comment

by:Bright01
ID: 40624192
Got it!  It's now working.  Thank you.

B.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question