ExcelBanter - What is VSync

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What is VSync (https://www.excelbanter.com/excel-discussion-misc-queries/127095-what-vsync.html)

I have the same spredsheet open twice. Normaly this is not a problem but for
some reason I know get a vSync in the title bar and when I scroll one copy
both move.

How can I stop this?

Goto Windows menu and uncheck "Compare Side By Side......"

"Keith" wrote:

I have the same spredsheet open twice. Normaly this is not a problem but for
some reason I know get a vSync in the title bar and when I scroll one copy
both move.

How can I stop this?

VSync only appears in window captions if you're using the old style windows
syncing (pre-Compare side-by-side).

That option used to be part of the UI but no more. To unset VSync you have
to use a macro:

Sub ResetWinSync()
Windows.Arrange ActiveWorkbook:=True, synchorizontal:=False,
syncvertical:=False
End Sub
--
Jim
"Keith" wrote in message
...
|I have the same spredsheet open twice. Normaly this is not a problem but
for
| some reason I know get a vSync in the title bar and when I scroll one copy
| both move.
|
| How can I stop this?