ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving 2 windows (https://www.excelbanter.com/excel-programming/325578-saving-2-windows.html)

John Allen

Saving 2 windows
 
I have a single spreadsheet with 2 windows open. The vertical split is 60/40.
When I open the file this split has not saved and I have a 50/50 split and
there is no synchronised scrolling between the 2 windows. If I click on
compare side by side with, the window reverts to 60/40 and synchronised
scrolling is effective. These settings are not saved, so on File Open, I need
to repeat this procedure.

Is there any way to save these settings or program an Auto Open macro to
present the 60/40 split with scrolling?

Harald Staff

Saving 2 windows
 
Hi

Save the file. Then save the workspace (also in File menu). Open the
workspace later on and you have it.

This works also for arrangements of windows of multiple files.

HTH. Best wishes Harald

"John Allen" <John skrev i melding
...
I have a single spreadsheet with 2 windows open. The vertical split is

60/40.
When I open the file this split has not saved and I have a 50/50 split and
there is no synchronised scrolling between the 2 windows. If I click on
compare side by side with, the window reverts to 60/40 and synchronised
scrolling is effective. These settings are not saved, so on File Open, I

need
to repeat this procedure.

Is there any way to save these settings or program an Auto Open macro to
present the 60/40 split with scrolling?




NickHK

Saving 2 windows
 
Harald,
All this time, that's something that I've never noticed/used.
Yesterday was the benefits of Shift+Edit.

Something new everyday.

NickHK

"Harald Staff" wrote in message
...
Hi

Save the file. Then save the workspace (also in File menu). Open the
workspace later on and you have it.

This works also for arrangements of windows of multiple files.

HTH. Best wishes Harald

"John Allen" <John skrev i melding
...
I have a single spreadsheet with 2 windows open. The vertical split is

60/40.
When I open the file this split has not saved and I have a 50/50 split

and
there is no synchronised scrolling between the 2 windows. If I click on
compare side by side with, the window reverts to 60/40 and synchronised
scrolling is effective. These settings are not saved, so on File Open, I

need
to repeat this procedure.

Is there any way to save these settings or program an Auto Open macro to
present the 60/40 split with scrolling?







All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com