Bottom of spreadsheet hidden in full screen view

M

Mio

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???
 
M

Mio

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?
 
K

keithl816

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
 
M

Mio

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.
 
K

keithl816

How about autohiding the task bar?

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

Will that work
 
M

Mio

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
 
M

Mio

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.
 

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

Similar Threads

Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Text in note pane of "normal" display suddenly much larger 1
Hidden Excel mystery 0
Excel Spreadsheet File Names not appearing on Task Bar 1
Screen view 2
View more than 1 spreadsheet at a time in Excel? 5
Cannot unhide the hidden rows in my spreadsheet 3
Excel Viewer: multiple docs in Task bar (XP) 0

Top