Automatically go to another cell

[Triple]

Can cell a1 have a go to command sending cursor/selection to b11 when a1 is
clicked on? Or can shortcut keys (ctrl,home) be set to stop in b11 instead of
a1?

 

[Don Guillett]

You can protect other cells and the sheet and then use the tab key to goto
the next unprotected.
OR right click sheet tab>view code>insert this. Could be put into
worksheet_change event to make truly automatic

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Address = "$A$1" Then Range("b11").Select
End Sub