View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mic Mic is offline
external usenet poster
 
Posts: 17
Default Tabbing thru User-Edit Cells in Protected Sheet

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.

"ConfusedNHouston" wrote:

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