View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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?