Textbox disappears in freeze panes

[Waititi]

Hi,

I am trying to use the Tab key to swap the focus between 3 textboxes in a spreadsheet as follow:

' Code in sheet1

Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
Sheet1.TextBox2.Activate
End If
End Sub
Private Sub TextBox2_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
Sheet1.TextBox3.Activate
End If
End Sub
Private Sub TextBox3_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
Sheet1.TextBox1.Activate
End If
End Sub


This code works fine except if texboxes are in a freeze pane, the activated textbox disappears and appears again if I click on it.
If the textbox is half in a freeze panes and half on the sheet, the textbox is half hatched

Is it a bug?
Is there a way to make it work properly?

Thanks for your help
Waititi

[Waititi]

Hi again,

I forgot to say I saw the problem with excel 2000 and 2003 but it works fine with excel97.

Cheers,
Waititi