| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move cursor out of sight
I just got great help from Gary''s Student and Beege so thanks to them!
But like usually, a solution just brings more questions... So I'm wondering if it is possible move the cursor out of sight and still stay at the same view? I have an Worksheet_SelectionChange event that moves my selected cell to the upper left corner and I would like to have that cell deselected efter that. I mean so that it wouldn't be on the same view at all. Is this possible? If yes, please help me! Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move cursor out of sight
Dim sr As Long, sc As Integer
sr = ActiveWindow.ScrollRow sc = ActiveWindow.ScrollColumn 'your code here to select a different cell ActiveWindow.ScrollRow = sr ActiveWindow.ScrollColumn = sc HTH, James "DaveFinn" wrote in message ... I just got great help from Gary''s Student and Beege so thanks to them! But like usually, a solution just brings more questions... So I'm wondering if it is possible move the cursor out of sight and still stay at the same view? I have an Worksheet_SelectionChange event that moves my selected cell to the upper left corner and I would like to have that cell deselected efter that. I mean so that it wouldn't be on the same view at all. Is this possible? If yes, please help me! Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move cursor out of sight
Thanks James!
This was just what I was looking for. "Zone" wrote: Dim sr As Long, sc As Integer sr = ActiveWindow.ScrollRow sc = ActiveWindow.ScrollColumn 'your code here to select a different cell ActiveWindow.ScrollRow = sr ActiveWindow.ScrollColumn = sc HTH, James "DaveFinn" wrote in message ... I just got great help from Gary''s Student and Beege so thanks to them! But like usually, a solution just brings more questions... So I'm wondering if it is possible move the cursor out of sight and still stay at the same view? I have an Worksheet_SelectionChange event that moves my selected cell to the upper left corner and I would like to have that cell deselected efter that. I mean so that it wouldn't be on the same view at all. Is this possible? If yes, please help me! Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move cursor out of sight
You're welcome. And thanks for the feedback. James
"DaveFinn" wrote in message ... Thanks James! This was just what I was looking for. "Zone" wrote: Dim sr As Long, sc As Integer sr = ActiveWindow.ScrollRow sc = ActiveWindow.ScrollColumn 'your code here to select a different cell ActiveWindow.ScrollRow = sr ActiveWindow.ScrollColumn = sc HTH, James "DaveFinn" wrote in message ... I just got great help from Gary''s Student and Beege so thanks to them! But like usually, a solution just brings more questions... So I'm wondering if it is possible move the cursor out of sight and still stay at the same view? I have an Worksheet_SelectionChange event that moves my selected cell to the upper left corner and I would like to have that cell deselected efter that. I mean so that it wouldn't be on the same view at all. Is this possible? If yes, please help me! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my cursor scrolls off the bottom out of sight. | Excel Discussion (Misc queries) | |||
| move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
| Move the cursor to the next row | Excel Programming | |||
| Move cursor to next row | Excel Discussion (Misc queries) | |||
| HOW TO MOVE CURSOR | Excel Programming | |||
Linear Mode
