Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub-window not moving or maximizing?
Everytime I open one of my documents "task list", The entire Excel program
opens full screen, but the individual file window stays shrunk at the bottom and not even entirely showing. I am not able to maximize or move it (using right click) The file still seems to function Other files do not have the problem (they open fully) Even when putting Excel into full screen mode, the file page stays small and below the screen. Has anyone seen this before and know how to fix it? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub-window not moving or maximizing?
Click on the window to make it Active and run this tiny macro:
Sub fill_the_space() ActiveWindow.WindowState = xlMaximized End Sub -- Gary's Student gsnu200707 "MTAR" wrote: Everytime I open one of my documents "task list", The entire Excel program opens full screen, but the individual file window stays shrunk at the bottom and not even entirely showing. I am not able to maximize or move it (using right click) The file still seems to function Other files do not have the problem (they open fully) Even when putting Excel into full screen mode, the file page stays small and below the screen. Has anyone seen this before and know how to fix it? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub-window not moving or maximizing?
The Macro is written correctly, as it works perfectly on other excel files,
but does not work on this file. Your solution did not work, but thanks for trying. I do have two other marcos enbedded in the file that I can get to work, but this file does not want to maximize. Any other ideas? Thanks! "Gary''s Student" wrote: Click on the window to make it Active and run this tiny macro: Sub fill_the_space() ActiveWindow.WindowState = xlMaximized End Sub -- Gary's Student gsnu200707 "MTAR" wrote: Everytime I open one of my documents "task list", The entire Excel program opens full screen, but the individual file window stays shrunk at the bottom and not even entirely showing. I am not able to maximize or move it (using right click) The file still seems to function Other files do not have the problem (they open fully) Even when putting Excel into full screen mode, the file page stays small and below the screen. Has anyone seen this before and know how to fix it? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
undo split window moving at the same time | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Window maximizing annoyance | Excel Discussion (Misc queries) | |||
In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
Profit Maximizing Using Solver | Excel Discussion (Misc queries) |