Jumping screen problem.

[Sarkonis]

Hi Guys,

Been searching all over and not finding very little about this problem.

I have a spreadsheet I keep all my business data in, been using it quite a while. Suddenly it has developed a problem where each time I click on a different cell the screen jumps around and tries to center the new cell on my screen. Based on my research it has something to do with "snap to cell". I have no idea what this is, or where to find it.

How do I make this stop? It's driving me insane having to reset my horizontal/vertical position every time I enter a new cell!

Why did it suddenly start doing this?!

TIA!

 

[igold]

I have no idea if this will work or not but I did a quick Google and this was returned. If it does not work you could always just re-check the box...

[h=2]How to disable Excel's "Snap to cell" scrolling[/h]
[FONT=&quot]To disable this feature:

Open: Control panel > System and security > System > Advanced system settings (in upper-left side) > Advanced tab > Settings in Performance box > Visual effects: > Untick "Animate controls and elements inside windows", and press ok.
​

[/FONT]

 

[Logit]

.
Let me know if this works ...

https://support.office.com/en-us/ar...n-or-off-817da2d4-40cc-4cff-b0de-1359ecbe95e3

 

[Sarkonis]

I have no idea if this will work or not but I did a quick Google and this was returned. If it does not work you could always just re-check the box...

How to disable Excel's "Snap to cell" scrolling


To disable this feature:

Open: Control panel > System and security > System > Advanced system settings (in upper-left side) > Advanced tab > Settings in Performance box > Visual effects: > Untick "Animate controls and elements inside windows", and press ok.
​

Slow reply, had a busy week.
This works, unfortunately it also works for other programs where I want this feature enabled... This is a temporary fix for now.

Logit, this seems to be if you use excel for pictures or drafting, so you can use the grid to size and align objects. Thanks for the look though.

 

[igold]

It was a shot in the dark. I am glad you can get some temporary relief though. Thanks for the feedback!

 

[Sarkonis]

No no, thank you for the help. I thought I was going to have to rebuild hundreds of hours of work. This saves my sanity at the very least!

 

[Sarkonis]

I have no idea if this will work or not but I did a quick Google and this was returned. If it does not work you could always just re-check the box...

How to disable Excel's "Snap to cell" scrolling


To disable this feature:

Open: Control panel > System and security > System > Advanced system settings (in upper-left side) > Advanced tab > Settings in Performance box > Visual effects: > Untick "Animate controls and elements inside windows", and press ok.
​

I currently have this feature unticked. Excel worked fine for a few days. Now, on it's own accord, it has started jumping around worse than before. It's unusable at this point. I have not changed any code or functions. All I have done since is manually input data line by line.

Mind of it's own I tell you.

 

[igold]

I wish could help you but my Google searches are not going to return anything different than yours...

Good Luck! If you do figure it out, post it for future reference...

 

[Sarkonis]

Thanks for the check up igold. Always appreciated.

I've been going back through the spreadsheet to try to figure this out. I realized that some of the code in other sheets was being copied into this one when I copied the template. Had a total facepalm moment and realized that the VBA code is what is causing this. This is the code I'm using to transpose items to an upper line where it then calculates further based on the active line keeping some variables constant.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row <= 3 Then Exit Sub
Application.EnableEvents = False
Range("A" & ActiveCell.Row).Resize(, 2).Copy Range("A3")
Range("C" & ActiveCell.Row).Resize(, 2).Copy
Range("C3").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Target.Select
Range("G" & ActiveCell.Row).Resize(, 3).Copy
Range("G3").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Target.Select
Application.EnableEvents = True
End Sub

Is there any way to keep this code working but rewrite it to prevent it from snapping the screen around?
Also, any idea why this code would work yet not cause the screen to jump around for a few months, and suddenly cause it to do so?

Thanks in advance!

 

[igold]

Did you try turning off Screen Updating...

Application.ScreenUpdating = False
    
    'Your Code
    
Application.ScreenUpdating = True