How to make TAB key work in a protected worksheet

I have protected a worksheet in excel 2003 and have used allowedits to make
some rows editable. I noticed that when I pressed the TAB key, it is not
moving to the next cell. It remains in the same cell. TAB key is not working.
Is there any option for making the TAB key work?

Hi Sri,
TRY THIS :
Sub TabENABLED()
Application.OnKey "{tab}", "PROCEDURE1"
End Sub

Sub PROCEDURE1()
ActiveCell.Offset(0, 1).Select
End Sub



rgds,

halim
Sri Ram menuliskan:
> I have protected a worksheet in excel 2003 and have used allowedits to make
> some rows editable. I noticed that when I pressed the TAB key, it is not
> moving to the next cell. It remains in the same cell. TAB key is not working.
> Is there any option for making the TAB key work?