Excel 2010 "Full Screen" & hide the "+" above hidden columns 1

[PWD]

Good morning, in Excel 2010 we want to be able to be able to hide - well everything that we can. I would appreciate suggestions for any improvements on what we've got so far, sitting in Module "ThisWorkbook":-

Private Sub Workbook_Open()

    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
    Application.DisplayFullScreen = True
    
    For x = 1 To ActiveWorkbook.Worksheets.Count
        
    Sheets(x).Select
  
        With ActiveWindow
            .DisplayHeadings = False
            .DisplayHorizontalScrollBar = True
            .DisplayVerticalScrollBar = True
            .DisplayWorkbookTabs = False
        End With
     
    Next x
    
    Application.DisplayStatusBar = False
    Application.DisplayFormulaBar = False

Sheets("Contents").Activate
Range("E10").Activate

End Sub

This actually seems to do what we want, except for it leaves one tab with a grey area above the data that still shows the "+" unhide columns still visible.

Any ideas on how to hide that bit? I'm not even sure what it's called.

Many thanks,
D€$

 

[SkipVought]

hi,

Its columns that have been grouped in some way. It is really a user control button to quickly hide/unhide those columns.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gavona]

    ActiveWindow.DisplayOutline = False

It is the Data, Group and Outline functionality. There a button as Skip says. Using it generates the above code.

Gavin

 

[PWD]

Resultio!!!

Many thanks,
D€$