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?
|