Solved

Protected Cell Progression

Posted on 2015-02-21
2
52 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

809 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