Full Screen With Status Cut Worksheet Tabs in Half
 

I want the workbook to open in Full Screen mode and show
the worksheet tabs. I placed this code in the VBA...
Application.WindowState = xlMaximized
Application.DisplayFullScreen = True
Application.DisplayStatusBar = True
However, the tabs for the worksheets are cut-off. I was
wondering how to fix this or maybe how to get the
appliaction title to show and that might fix it.

Any ideas from the community?

Full Screen With Status Cut Worksheet Tabs in Half
 

Hi Dean,

The Taskbar is probably blocking the Status Bar and the
lower part of the tabs. If you set the Taskbar
properties to Auto-hide, the problem resolves on my WinXP
and Excel XP setup.

Best Regards,
Walt

-----Original Message-----
I want the workbook to open in Full Screen mode and show
the worksheet tabs. I placed this code in the VBA...
Application.WindowState = xlMaximized
Application.DisplayFullScreen = True
Application.DisplayStatusBar = True
However, the tabs for the worksheets are cut-off. I was
wondering how to fix this or maybe how to get the
appliaction title to show and that might fix it.

Any ideas from the community?
.

Full Screen With Status Cut Worksheet Tabs in Half
 

I thought about that but I do not want to change ever PC in the plant to
do so. There must be a way to do that properly or get the title bar
back.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!