MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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