Bottom of spreadsheet hidden in full screen view

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

Guest

If you change Excel to Full Screen View and your taskbar is always on top (as
it normally is), the bottom of the spreadsheet is hidden behind the taskbar.
Does anyone know how to get around this without hiding the taskbar? I have
found that if I drag the taskbar to the bottom and then back up again, the
Excel window resizes itself correctly and the bottom of the spreadsheet is
visible again. Problem is, I want to do this from VBA! Can anyone help
please???
 
Bringing this post back to the top because it is getting lost in the depths
of the forum. I've searched the whole Excel forum pretty much and a couple
of people have asked this question, but no answers. Does anyone know how to
resolve this?
 
Try going back to the normal screen and reduce the zoom from 100% t
about 90%. or whatever is needed to be able to show the bottom of th
sheet.

Would that help you?

Larr
 
Thanks for trying, but unfortunately that doesn't help. By changing the zoom
level all you are doing is allowing more to be seen within the window, not
reducing the size of it. As it happens, I already have the zoom level set to
90% anyway.
 
How about autohiding the task bar?

Right click task bar at bottom and go to properties. check autohide th
task bar.

Will that work
 
It might work, but it doesn't do what I want. The app that i'm writing can
run on anyone's pc, and I don't want to start changing their desktop, i.e. I
need this to work whether the taskbar is fixed or hidden
 
Keith

Many thanks for your efforts. Unfortunately, I'm still no better off. I
did the coding which your link suggested yesterday - that's when I came up
with the problem and hence this post. What the code does is make it a full
screen display and removes the menu and toolbars. However, it doesn't do
anything about making the Excel window the right size taking into account the
taskbar.
 
Back
Top