Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What Instruction?
Have a sheet where all cells locked except col A.
If a value is entered in A I unlock cell in col C. However the cursor mpoves to col A on the next line rather than to the newly unlocked cell on the same line. What instruction moves the cursor to cell in col C? John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What Instruction?
HI John
If you are working on Excel 2007, You can change the cursor movement as per your choice. Click on the Windows button on the top left corner and choose "Excel Options" now click on "Advanced" tab and you will find the option to change cursor movement under Editing Options. Here you can specify the cursor to move to the cell in right side instead of down. Pls click yes if it helps. Avi "johnsail" wrote: Have a sheet where all cells locked except col A. If a value is entered in A I unlock cell in col C. However the cursor mpoves to col A on the next line rather than to the newly unlocked cell on the same line. What instruction moves the cursor to cell in col C? John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What Instruction?
Put this event macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range) Dim rc As Range Set t = Target Set ra = Range("A:A") If Intersect(t, ra) Is Nothing Then Exit Sub Set rc = t.Offset(0, 2) rc.Locked = False rc.Select End Sub -- Gary''s Student - gsnu200836 "johnsail" wrote: Have a sheet where all cells locked except col A. If a value is entered in A I unlock cell in col C. However the cursor mpoves to col A on the next line rather than to the newly unlocked cell on the same line. What instruction moves the cursor to cell in col C? John |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What Instruction?
Hi Avi
Am using Excel 2003 SP3. The unlocking of cells isbeing done by VB and changing the cursor direction makes no difference. John "Aviral Sharma" wrote: HI John If you are working on Excel 2007, You can change the cursor movement as per your choice. Click on the Windows button on the top left corner and choose "Excel Options" now click on "Advanced" tab and you will find the option to change cursor movement under Editing Options. Here you can specify the cursor to move to the cell in right side instead of down. Pls click yes if it helps. Avi "johnsail" wrote: Have a sheet where all cells locked except col A. If a value is entered in A I unlock cell in col C. However the cursor mpoves to col A on the next line rather than to the newly unlocked cell on the same line. What instruction moves the cursor to cell in col C? John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blocking Cells if instruction not followed | Excel Discussion (Misc queries) | |||
how do I display an instruction in a cell? | Excel Discussion (Misc queries) | |||
A self Instruction Book On Excel 2003 | New Users to Excel | |||
How do I delete an instruction box? | Excel Worksheet Functions | |||
template for works instruction | New Users to Excel |