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?

How to make TAB key work in a protected worksheet
 

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?