PDA

View Full Version : Hide Workbook Title Bar



YasserKhalil
07-08-2010, 11:08 AM
I want to hide the workbook title bar (the blue one, with the workbook name,
the minimize, maximize and close buttons)

Bob Phillips
07-08-2010, 11:25 AM
Why?

omnibuster
07-08-2010, 01:00 PM
Try.
Sub FullScr()
Application.CommandBars("Worksheet menu bar").Enabled = False
Application.DisplayFullScreen = True
Application.OnTime Now + TimeValue("00:00:05"), "Macro1"
End Sub
Sub Macro1()
Application.DisplayFullScreen = False
End Sub

YasserKhalil
07-08-2010, 04:15 PM
Mr. xld
You asked me why??
It's just t prevent the user from using close button and to fill the screen..
FullScreen property dosen't hide title bar