Move cursor out of sight

G

Guest

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!
 
Z

Zone

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
my cursor scrolls off the bottom out of sight. 1
Smooth scroll of a DataGridView cell with large amount of data 3
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Move and size a object on the sheet 1
data validation, mouse action of select... then move right 2
application.goto 4
Completing Form Fields - Cursor Direction 1

Top