Hide Drop Down Arrows in Table Headers

  • Thread starter Thread starter Steve Haack
  • Start date Start date
S

Steve Haack

I'm using Excel 2007. I select a range and define it as a table. Excel puts
drop down arrows on the column headers.

Is there any way to hide the drop downs, and still keep the range as a table?

Steve
 
Hi Steve

As far as I am aware, there is no setting for this.
The following code will switch the arrows off. Similar code with the
attribute set to True will switch them back on

Sub HideArrows()
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False
For Each c In Range(Cells(1, 1), Cells(1, i))
c.AutoFilter Field:=c.Column, visibledropdown:= False
Next
Application.ScreenUpdating = True
End Sub
 
In 2003 I would go to Tools>Options>View>Objects>Hide All


Gord Dibben MS Excel MVP
 
Hi Gord

Unfortunately in XL2007
Round Office button>Excel options>Advanced
Display options for this Workbook>For Objects show >Nothing (Hide Objects)
does not prevent the filter buttons on Tables from being hidden.
 
Back
Top