Bottom of spreadsheet hidden in full screen view

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

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?

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

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

Step 1: Close all your windows explorer windows. Run Task Manager(Typing Ctrl-Alt-Del->Task Manager is one way). Go to the "Processes" tab. Sort by 1st column "Image name". Look for explorer.exe in the 1st column. Select this and click End Task and confirm to delete. Task bar would now become invisible.

Step 2" In task manager, Go to "File - New Task(Run)" and type explorer.exe and click Ok. The taskbar should reappear and Your problem with the excel window getting behind the task bar should go away.