Delete or hide the title bar of Excel 2007 / 2010 / 2013

[ivairferrari]

Hi !

I need to delete or hide the title bar of Excel 2007 / 2010 / 2013. Could you help me.

Thank you!

Ivair Claudio Ferrari
Excelmax Soluções, Excel, Software, Simulador, Gráfico, Macro, VBA.
Brazil

 

[mgm05267]

Hi Ivair,

Welcome to the board..

May be the link below might help...

http://www.mrexcel.com/forum/excel-questions/6148-possible-hide-excel-title-bar.html

 

[ace19852]

you could check out the post put

• HIDE TITLE BAR For EXCEL 2007 ???

in the search box.

However I prefer to put this following which can removes everything if you change True to False and False to True have a play. You probably can work what does what by the code name Application.**********

Note this doesn't disable the mouse right click option that another question


Put this under ThisWorkbook

Private Sub Workbook_Open()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
Application.DisplayFullScreen = False
Application.DisplayStatusBar = True
Application.DisplayFormulaBar = True
ActiveWindow.DisplayHeadings = True
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
ActiveWindow.DisplayGridlines = True
Application.ErrorCheckingOptions.BackgroundChecking = True
Application.CommandBars("Status Bar").Visible = True
ActiveWindow.WindowState = xlNormal
ActiveWindow.DisplayWorkbookTabs = True
Application.ScreenUpdating = True
End Sub

Cheers

 

[ivairferrari]

Hello!


Sorry for insisting but the title bar remains visible.
Look at the picture.

Thank you!
Ivair CLaudio Ferrari

 

[ace19852]

Hello!


Sorry for insisting but the title bar remains visible.
Look at the picture.

Thank you!
Ivair CLaudio Ferrari

Unfortunately the picture doesn't show and just to be sure in the code I sent you did change the True to False and the False to True ? Otherwise nothing will happen.

Cheers