Full Screen With Status Cut Worksheet Tabs in Half

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

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?
 
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
 
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!
 
Back
Top