Worksheets do not open Arranged
 

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?

Worksheets do not open Arranged
 

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
MVP Excel
http://people.stfx.ca/bliengme

"Howard Kaikow" wrote in message
...
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?

Worksheets do not open Arranged
 

"Bernard Liengme" wrote in message
...
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.

Worksheets do not open Arranged
 

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" wrote in message
...
"Bernard Liengme" wrote in message
...
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.

Worksheets do not open Arranged
 

"Peter T" <peter_t@discussions wrote in message
...
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,