Jumping like a frog
Posted by Oeloel on August 06, 2000 3:03 PM
Hi, everyone out there! Please give me a valuable hand with this. When you move across a sheet in Excel'97, is it possible to have Excel behave like a form where by leaving specific cells by pressing tab or arrow you are only allowed to jump to unprotected cells? Any protected cell is skipped. I have a sheet where only 15 cells are maintainable yet some of them are far one from each other. I want to prevent the users from lots of endless tabbing. Please help. Thank you.
Posted by JAF on August 07, 0100 2:15 PM
Take a look at 3023.html
That should give you what you need.
Posted by David on August 06, 0100 10:15 PM
Inside a sheet that I use I do something similar, In that if the focus is on a certain cell then I jusmp to a different cell. Hope this helps.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim Ans As Integer
If Target.Address = "$J$3" Then
range("L13").select
end if
end sub
