View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] halimnurikhwan@yahoo.com is offline
external usenet poster
 
Posts: 113
Default 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?