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