Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
"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
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
"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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scrolling with two worksheets arranged vertically | Excel Discussion (Misc queries) | |||
Excel should let its worksheets be arranged (tiled) in a workbook | Excel Worksheet Functions | |||
How to keep sheets displayed(arranged) when moving between them? | Excel Worksheet Functions | |||
Printing from Arranged View | Excel Discussion (Misc queries) | |||
"Arranged" files scroll together | Excel Discussion (Misc queries) |