Sub-window not moving or maximizing?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Click on the window to make it Active and run this tiny macro:

Sub fill_the_space()
ActiveWindow.WindowState = xlMaximized
End Sub
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top