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?

"Mio" wrote:

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

Try going back to the normal screen and reduce the zoom from 100% to
about 90%. or whatever is needed to be able to show the bottom of the
sheet.

Would that help you?

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491486

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.

"keithl816" wrote:


Try going back to the normal screen and reduce the zoom from 100% to
about 90%. or whatever is needed to be able to show the bottom of the
sheet.

Would that help you?

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491486

How about autohiding the task bar?

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

Will that work?


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491486

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

"keithl816" wrote:


How about autohiding the task bar?

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

Will that work?


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491486

Try going here see if this will help you

http://www.ozgrid.com/forum/showthre...t=hide+toolbar


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491486

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.

"keithl816" wrote:


Try going here see if this will help you

http://www.ozgrid.com/forum/showthre...t=hide+toolbar


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=491486