Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically copy cell contents from one cell into anot | New Users to Excel | |||
Move cell data to another worksheet cell automatically. | New Users to Excel | |||
Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
How to Automatically Move Cell datato adjacent cell.. | Excel Discussion (Misc queries) |