Excel Maximized Larger than Screen?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I was on a PC yesterday where Excel Maximized was larger
than the PC Screen ... very annoying ... What is the setup
required to set Excel Maximized to PC Screen Size ... As
always ... My many Thanks to those of you that support
this board ... Kha ...
 
Do you mean excel or a workbook within excel?

If you meant excel, then I'm gonna guess (and it's just a guess) that either
windows got confused (or you changed the display properties for your windows
setting 1024x768 type of thing).

I'd resize it and see if that fixed the problem. If it did, I'd chalk it up to
one time thing.

On the other hand, if you meant a workbook within excel, maybe the workbook was
last saved on a pc with different display settings than you.

If you record a macro when you maximize the window and plop that code into an
Auto_open routine, then maybe you won't care who saves the file last.

This'll get both the workbook/worksheet window and the application window:

Option Explicit
Sub auto_open()
ActiveWindow.WindowState = xlMaximized
Application.WindowState = xlMaximized
End Sub

(again, I think if you maximize the application, then windows should be smart
enough to resize it. But maybe toss in a .windowstate = xlnormal to see if
shrinking and then maximizing works.)

<<Any chance that I'm close?>>
 
Back
Top