I
IanC
I have a template created in Excel 2000 which works as expected in
Excel 2000. If I use it in Excel 2010, the tabbing locks up at some
points and refuses to move on.
The template (and obviously the file created from it) is protected and
much of the sheet is locked. The unlocked areas consist of merged
cells & single cells. These are NOT named ranges, but for
simplification of this description I will name them:
A=S2:U2
B=B4
4
C=M5:U11
D=E6:K6
E=C8:G8
F=J8:K8
G=K10
H=D12:K13
etc
T=U28
U=A31
34
V=R32:T32
etc
Initially, the cursor is in A and I would expect to be able to tab
through A,B,C,D,E,F etc. This works in Excel 2000, but in Excel 2010
it goes A,B,C,D,C,D,C,D etc. If I click in E the tabbing will continue
as expected until it reaches U when it hangs up and won't tab to
anywhere. If I click into V, it then continues as expected to the end
of the sheet and loops back to A,B etc
I looked carefully at the formatting of the probelm areas and found
that both were partially locked and that this was only in Excel 2010.
If I unprotect the sheet and unmerge M5:M11 then merge them again and
protect the sheet, I can tab through A,B,C,D,E etc. I tried adding
code to the workbook to remove the locked cells and, although the
whole area is now unlocked, ith still gets stuck in the C,D,C,D loop.
This is the code I used to unlock the cells.
Private Sub Workbook_Open()
With Worksheets("Service Report")
.Unprotect
Application.ScreenUpdating = False
With .Range("M5:U11")
.UnMerge
.Locked = False
.Merge
End With
.Protect
End With
Application.ScreenUpdating = True
End Sub
Any suggestions will be most welcome.
Excel 2000. If I use it in Excel 2010, the tabbing locks up at some
points and refuses to move on.
The template (and obviously the file created from it) is protected and
much of the sheet is locked. The unlocked areas consist of merged
cells & single cells. These are NOT named ranges, but for
simplification of this description I will name them:
A=S2:U2
B=B4
4C=M5:U11
D=E6:K6
E=C8:G8
F=J8:K8
G=K10
H=D12:K13
etc
T=U28
U=A31
34V=R32:T32
etc
Initially, the cursor is in A and I would expect to be able to tab
through A,B,C,D,E,F etc. This works in Excel 2000, but in Excel 2010
it goes A,B,C,D,C,D,C,D etc. If I click in E the tabbing will continue
as expected until it reaches U when it hangs up and won't tab to
anywhere. If I click into V, it then continues as expected to the end
of the sheet and loops back to A,B etc
I looked carefully at the formatting of the probelm areas and found
that both were partially locked and that this was only in Excel 2010.
If I unprotect the sheet and unmerge M5:M11 then merge them again and
protect the sheet, I can tab through A,B,C,D,E etc. I tried adding
code to the workbook to remove the locked cells and, although the
whole area is now unlocked, ith still gets stuck in the C,D,C,D loop.
This is the code I used to unlock the cells.
Private Sub Workbook_Open()
With Worksheets("Service Report")
.Unprotect
Application.ScreenUpdating = False
With .Range("M5:U11")
.UnMerge
.Locked = False
.Merge
End With
.Protect
End With
Application.ScreenUpdating = True
End Sub
Any suggestions will be most welcome.