Automatically go to another cell
 

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?

Automatically go to another cell
 

You can protect other cells and the sheet and then use the tab key to goto
the next unprotected.
OR right click sheet tabview codeinsert 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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Triple" wrote in message
...
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?