Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells
When a user is in cell K10 (merged cells going to V10) and tabs, I would like
it to go to A15. Anyone know the code behind this. The code below is what I have stated in ThisWorkbook Code, but still doesn't eliminate the user from going past K10? Any help would be appreciated. Thanks Private Sub Workbook_SheetActivate(ByVal sh As Object) With ActiveSheet .ScrollArea = "A1:V96" End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column 10 Then Set Target = Target.Worksheet.Cells(Target.Row + 1, 1) If Target.Row 10 Then Set Target = Target.Worksheet.Cells(1, 1) Target.Activate End Sub This won't let the user enter a cell that is outside the range A1:J10 in the worksheet. Cheers, Jason Lepack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting multiple cells, I can't see the cells highlighted | Excel Discussion (Misc queries) | |||
Selecting too many cells | Excel Discussion (Misc queries) | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
selecting cells | Excel Discussion (Misc queries) |