Worksheets do not open Arranged

[Howard Kaikow]

As of a few daze ago, I see the following problem.

When I open a new, or extant, workbook, the sheet(s) are not Arranged to fit
the Window.

I have to use the Window menu to Arrange as desired.

I had this same issue several years ago.

As a last resort, I'd use an AutoOpen macro, but my recollection is that
there was a Data key, or somthing like that, in the registry and I was able
to fix things by deleting that registry key.

I've used Windows.Arrange, but the settings do not stick when I save the
workbook.

Anyone know the trick?

 

[Bernard Liengme]

Do you mean that the workbook appears within the Excel working area and it
is not fully expanded?
Open an existing workbook; expand it to fill the window and do a Save
Exit Excel
Now when you start Excel the new workbook will fill the workarea
best wishes

 

[Howard Kaikow]

Do you mean that the workbook appears within the Excel working area and it
is not fully expanded?
Yes.

Open an existing workbook; expand it to fill the window and do a Save
Exit Excel
Now when you start Excel the new workbook will fill the workarea
best wishes

Alas, still an issue.

 

[Peter T]

Try this -

Close all instances of Excel, incl any hidden ones
Open Excel
Maximise the default workbook (Book1) window inside the main Excel
Close Excel ' <<<

Regards,
Peter T

 

[Howard Kaikow]

Try this -

Close all instances of Excel, incl any hidden ones
Open Excel
Maximise the default workbook (Book1) window inside the main Excel
Close Excel ' <<<

Thanx fer the suggestion.
Did not fix the problem.

Guess that I'll have to hunt thru registry for the data key,