View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DaveFinn DaveFinn is offline
external usenet poster
 
Posts: 12
Default 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!