Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 4,393
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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.




  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default 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,




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scrolling with two worksheets arranged vertically Richard Champlin Excel Discussion (Misc queries) 4 December 17th 07 03:43 PM
Excel should let its worksheets be arranged (tiled) in a workbook Stephen Flanders Excel Worksheet Functions 1 January 19th 06 07:20 PM
How to keep sheets displayed(arranged) when moving between them? Credo Excel Worksheet Functions 1 October 5th 05 06:46 PM
Printing from Arranged View Neo Excel Discussion (Misc queries) 1 August 26th 05 04:35 AM
"Arranged" files scroll together Not a Happy Camper Excel Discussion (Misc queries) 0 June 27th 05 03:23 PM


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"