Tabbing thru User-Edit Cells in Protected Sheet

  • Thread starter ConfusedNHouston
  • Start date
C

ConfusedNHouston

In a protected spreadsheet I have allowed user-edit for a range A10:B20.
However when the user tries to tab from A10 to B10; the tab does not take
them to column B. How can I configure the user-edit cells so that the user
can tab from column A to column B?

Thanks
 
M

Mic

Hey,
I am having the exact same problem.
If you let a user change a specified range, they should be able to do
everything they normally could within that range.
 
M

Mic

Hey,
I was just messing around and I figured this out.
Do this before you protect it.
Take your range of A10-B10 and format the cells, choose the last tab
"Protection" and take the checkmark off of "Locked".
Then apply your protection.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top