Worksheets do not open Arranged

  • Thread starter Thread starter Howard Kaikow
  • Start date Start date
H

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?
 
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
 
Bernard Liengme said:
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
Click to expand...

Alas, still an issue.
 
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
 
Peter T said:
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 ' <<<
Click to expand...

Thanx fer the suggestion.
Did not fix the problem.

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