Solved

Protected Cell Progression

Posted on 2015-02-21
2
50 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:
SimonAdept 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now