View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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?